recreate timestamp

crisg0112

Hi,

I have a date attribute and a timestamp attribute BUT the format is HH:mm

Based on this two attributes I want to create a new timestamp attribute

Is there a function in Aware that will allow me to do this?

hpl123

Cris,
Take a look at this post to see if you can get it to work:
https://forum.awareim.com/d/6935>

crisg0112

hpl123 wrote
Cris,
Take a look at this post to see if you can get it to work:
https://forum.awareim.com/d/6935>

Hi,

Thanks for replying. Yeah saw that post already but the problem is that the time is a constant time.

I tried to do the following but Aware is coming up with an error "exception while saving the object null".

TIMESTAMP(DAY_OF_MONTH(MyBO.Work_Date),MONTH(MyBO.Work_Date),MyBO(Timesheet.Work_Date),HOUR(MyBO.TimeFrom),MINUTE(MyBO.TimeFrom))

Also, why is the HOUR function expecting a date parameter which I find a bit weird?

maybe a TIME_PART function on the next build? Since we already have a DATE_PART that extracts only the date component of a timestamp attribute

hpl123

Cris,
Try going over how you use the function. What you wrote for example don´t look right:
TIMESTAMP(DAY_OF_MONTH(MyBO.Work_Date),MONTH(MyBO.Work_Date),MyBO(Timesheet.Work_Date),HOUR(MyBO.TimeFrom),MINUTE(MyBO.TimeFrom))

and also you don´t have YEAR as part of the function?

I have used this function before to do similar things but took me quite a few tries to get it working (syntax has to be correct etc.)

BobK

Try something like this:

BO.MyTimeStamp=AS_TIMESTAMP(AS_STRING(BO.TheDate, 'MM/dd/yy')+AS_STRING(BO.TheTime,'HH:mm'), 'MM/dd/yyHH:mm')

crisg0112

hpl123 wrote
Cris,
Try going over how you use the function. What you wrote for example don´t look right:
TIMESTAMP(DAY_OF_MONTH(MyBO.Work_Date),MONTH(MyBO.Work_Date),MyBO(Timesheet.Work_Date),HOUR(MyBO.TimeFrom),MINUTE(MyBO.TimeFrom))

and also you don´t have YEAR as part of the function?

I have used this function before to do similar things but took me quite a few tries to get it working (syntax has to be correct etc.)

thanks for the advice, will do