In incremental load the date field is in timestamp..how to identify the max date

[#1]

In incremental load the date field is in timestamp..how to identify  the max date

[#2]

try this

=date(max(floor(num( yourdatefield ))))

[jagan]

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.

[Anonymous]

Hi Use the below code to get the max date

=Max(Date([Date Field Name],'DD/MM/YYYY'))

[#5]

hi Bhawna Guptha,

    date field in secs how to convert dates

Thanks & Regards

Raja

[#6]

Hi Jagan,

date field in secs how to convert dates

Thanks & Regards

Raja

[jagan]

Hi,

can you post some sample dates?

Regards,

Jagan.

[avinashelite]

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

[#9]

hi avinash,

  in windows how to convert secs to date