Setting a TimeStamp Time

I am sure this must have been covered before but just can't find it for looking......

I want to set the Time of a Timestamp to the End of the Day.

I am trying like this with no joy....

DateTest.MyTime=TIME_STAMP(DATE_PART(DateTest.Date),23,99)

Log gives error.....

-Exception while calculating the action DateTest.MyTime=TIME_STAMP(DATE_PART(DateTest.Date),23,99)

Any suggestions would be greatly appreciated.

Minutes should be 59 not 99?

Cheers Rod

Try,

DateTest.MyTime=TIMESTAMP(DATE(DateTest.Date),23,99)

Minutes should be 59 not 99?

oops,

DateTest.MyTime=TIMESTAMP(DATE(DateTest.Date),23,59)

Did you try this Rennur?

It does not work for me. 😐

If DateTest.Date a timestamp, this should do it 🙂

DateTest.MyTime=TIMESTAMP(DAY_OF_MONTH(DATE_PART(DateTest.Date)),MONTH(DATE_PART(DateTest.Date)),YEAR(DATE_PART(DateTest.Date)),23,59)

Thats got it.

Phew! Lot of work just to set a time.

Thanx