How to turn a date into a timedate? 1

[Oona8]

Hi
I'm using CR8
I created a variable I named
@yesterday:

datevar yesterday;
yesterday := (currentdate-1)

I'd like to turn this variable into a Datetime variable that would give me yesterday's date AND time and the time should be 5pm all the time.
I tried various types of formulas, such as DTSToTimeString, or CTIME etc.. but none of them seems to work..

How could I do that?

 

[Naith]

Like this:

@yesterday:

WhilePrintingRecords;
DateTimeVar Yesterday;
Yesterday := DateTime(Year(CurrentDate),Month(CurrentDate),Day(CurrentDate),17,00,00);

All the best,

Naith

 

[Oona8]

Thanks very much Naith, it works!

Oona