DSXchange

Hi,
I've a job where I need to find out the specified date is in between the start date and end date or not.
I've gone through the date functions of PX but i couldn't find any.
Can anybody give me any idea how to do this in PX?

Thanks,
bilwakunj

Hi,

First convert all the dates in Date datatype. i,e if the datatype of the dates are String then use DateToString function to convert into Date datatype. After that simply use

(If Date > Date1 And Date < Date2) Then <Action1> Else <Action2>..

It will work.

Regards
~Amitava