End Date Wrongly Calculated
I have a Trial Expiry script than on open from a lockdown state compares the Current date to the End date.
When I set up the Start and End Trial dates the "unsafe" way, that is using Get (Current Date) to determine the Start date and from taht the End date, the script behaves as expected.
However, when I set it up the "safe" way, that is the developer enters the Trial Start date in the ZRESOURCES::gTrialStartDate field and the Trial Expiry script contains the following script steps:
the generated End date makes no sense and on the second start up the user gets the messsage: "Trial period has expired"
So for a zRESOURCES::gTrialStartDate of 18/12/2012 ( this is the date format on my machine under MS Windows 7 OS in Spain) the generated zRESOURCES::gEndDate is 20/01/0001
Somehow the date format for Spain and for most European countries dd/mm/yyyy is misinterpreted by FM 11 when used in a calculation.
Any clues how to sort it out so that I can use the "safe" way to set up Sart and End dates for the trial period of my runtime?