Regarding date manipulation

Bilwakunj · Post by **Bilwakunj** » Thu Mar 24, 2005 10:00 pm

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

gh_amitava · Post by **gh_amitava** » Fri Mar 25, 2005 1:04 pm

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