Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In incremental load the date field is in timestamp..how to identify the max date
try this
=date(max(floor(num( yourdatefield ))))
Hi,
To get the max date
MaxDateTable:
LOAD
Date(Floor(Max(DateDimensionName))) AS MaxDate
FROM DataSource;
LET vMaxDate = Peek('MaxDate');
DROP TABLE MaxDateTable;
Regards,
Jagan.
Hi Use the below code to get the max date
=Max(Date([Date Field Name],'DD/MM/YYYY'))
hi Bhawna Guptha,
date field in secs how to convert dates
Thanks & Regards
Raja
Hi Jagan,
date field in secs how to convert dates
Thanks & Regards
Raja
Hi,
can you post some sample dates?
Regards,
Jagan.
Hi Raja,
I think its in UNIX timestamp format ...if so try like this:
timestamp((datefield/ 86400 + 25569),'DD MMM YYYY h:mm:ss[.fff] TT')) as datefield
hi avinash,
in windows how to convert secs to date