Help with dates?

[qlikuser222]

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

[MarcoARaymundo]

in this case tray create a flag in load time..

if([Payment Date] >= StartDt and [Payment Date] <= EndDt, 1, 0) as Flag

[maxgro]

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$);