Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i have a requirement where i need to calculate the fields based on the date (for example Payment Date) which falls between two dates (for example start and end date).
PFA attached files for sample data.
Thanks
in this case tray create a flag in load time..
if([Payment Date] >= StartDt and [Payment Date] <= EndDt, 1, 0) as Flag
LOAD
*,
[Payment Date] >= StartDt and [Payment Date] <= EndDt as Flag
;
LOAD ID,
date(date#([Payment Date], 'YYYYMMDD')) as [Payment Date],
StartDt,
EndDt
FROM
[test.xls] (biff, embedded labels, table is Sheet1$);