convert datetimestamp to date for Master Calender

[#1]

Currently my database is using a datetimestamp instead of a date and i want to convert the date time stamp to a date. datewhen in the code below is a datetimestamp, 2009-10-29 00:00:00.000

vMinDate = Num(Peek('datewhen' 0 'transactions'));

it seems to me when i debug it seems to tells me the value of vMinDate=null

[#2 · Accepted solution]

I don't understand the usage of Peek here.

The Date# statement you could use looks like :

LET vDate = Date#('2009-10-29 00:00:00.000','YYYY-MM-DD hh:mm:ss.fff');

This can also be used in a load statement

[#3]

I was trying out with the samples of master calender from the developer training. The peek function was there