To get the In between values between two dates

[#1]

Hi all,

I need a help regarding , i have a 'Date' field for that i need to find out the dates which are in between two particular dates let say "1 may 2012" to "31 aug 2013" as a separate filed how it can be achieved. Please help me on the same.

Thanks in advance.

[sujeetsingh]

Why dont you directly derive a field

as :

If(Date>01/05/2012 and Date<31/08/2013 ,Date ,NULL()) as NewDate

[#3]

I tried that, but its not working..

[saumyashah90]

only({<Date={'>$(SartDate) <$(EndDate)'}>} Date);

[MayilVahanan · Accepted solution]

HI

Try in script

If(Floor(Date) >= Num(MakeDate(2012,05,01)) and Floor(Date) <= Num(MakeDate(2013,08,31)), Date ,NULL()) AS NewDate

[yduval75]

Hello,

You can try this :

If(Date*1>= MakeDate(2012,05,01)*1 and Date*1 <= MakeDate(2013,08,31)*1, Date ,NULL()) as NewDate