substract 2 months to a date

[Maxime C]

Hi,

I need to set a range for a perform find, this range needs to be from 2 months ago until today's date.

Do you know how could I create this "2 months ago" date

If we are 1/22/12, I would like to set a variable as 11/22/11

Any help would be appreciated,

Thank you

[No_access]

Try this , where "thisdate" is your date field...

Date ( Month ( thisdate )-2  ;   Day (thisdate ) ;  Year ( thisdate ) )

[comment]

Try something like:

Enter Find Mode [}

Set Field [ YourTable::Datefield ; Let ( t = Get (CurrentDate) ; Date ( Month ( t ) - 2 ; Day ( t ) ; Year ( t ) ) & "..." & t ) ]

Perrrform Find []

[Maxime C]

Thank you it worked, I was scared about January and February and the back decrease year impact but everything work fine.

Thx