How do I set up conditions with dates

[cysayles]

I have 3 date fields - [[First Order]] [[Last Order]] and [[Review]]

When I get a review I'd like to enter the date in an <IF statement> and compare against the last and first dates. Then send a thank you email for the review. The <else> sends the thank you email for the order.

Of course there may not be a last date.

I've tried for hours using the date format for MacOS and haven't found the combination.

Sure would appreciate some direction.

 

[stanbusk]

Have you tried the YYYY-MM-DD format?

--
Follow maxprog.com on Facebook | Google+ | Linkedin | Twitter | YouTube
and keep up-to-date with the latest Max Programming updates!

 

[cysayles]

Hi Stan,

I did try that without success. I sure I'm not the only one that's experiencing problems using conditional statements with dates, would it be possible for you to create some sample code along with some tips?

Cy

 

[stanbusk]

Looking at the code I believe you have to use your system settings, I mean same order and same separator.

--
Follow maxprog.com on Facebook | Google+ | Linkedin | Twitter | YouTube
and keep up-to-date with the latest Max Programming updates!