how to remove the time stamp from a date field in the script??
Can someone help me how to remove the time stamp from the date field in the script.
I googled and tried out
Date(Floor(TimeStamp#(Value, 'DD/MM/YYYY hh:mm:ss'))) but this does not work.
my script is like following:
LOAD Month as Date,
YearStart(Month) as date_,
Monthstart(Month) as pricing_beg_date,
Monthend(Month) as expiry_date,
so here Month is my date field but it has timestamp hence when I am calculating my rest of the derived fields I dont get exact values.I actually want the timestamp to be zero since I want to calculate only the date part.Can some one please help me out???