How to add Timestamp to an existing date field?
Lets say we have a date as: 2013-11-21
and we have hour of the timestamp as: 10
The hour ranges from 1 to 24
Is it possible to create a date time field which looks like
2013-11-21-10 or 2013-11-21 10:00:00
1 answer
FYI.. I've tried to create them as such
DATETIME(STR(YEAR([EVENT_DATE_PST_NKEY]))+"-"+
STR(MONTH([EVENT_DATE_PST_NKEY]))+"-"+
STR(DAY([EVENT_DATE_PST_NKEY]))+" "+
STR([EVENT_HOUR_PST_SKEY]))+":00:00")
DATETIME(STR([EVENT_DATE_PST_NKEY])+" "+STR([EVENT_HOUR_PST_SKEY])+":00:00")
The calculation shows no error but when I apply it in the worksheet, it gives error as
"Invalid Timestamp"
