Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
HI
Try in script
If(Floor(Date) >= Num(MakeDate(2012,05,01)) and Floor(Date) <= Num(MakeDate(2013,08,31)), Date ,NULL()) AS NewDate
Why dont you directly derive a field
as :
If(Date>01/05/2012 and Date<31/08/2013 ,Date ,NULL()) as NewDate
I tried that, but its not working..
only({<Date={'>$(SartDate) <$(EndDate)'}>} Date);
HI
Try in script
If(Floor(Date) >= Num(MakeDate(2012,05,01)) and Floor(Date) <= Num(MakeDate(2013,08,31)), Date ,NULL()) AS NewDate
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