Have you tried using the script step "Set using system formats" in your opening script ?
No I am not
I even tried to add this script step and put the set use system format Off but the problem persisted.
It is in fact taking the system date format
And what os more strange and somewhat dangerous is that the date field is displayed as day.month.year
and the dates appearing in the calculation appear as month.day.year
The sole solution might he to change the date format of the user's laptop!! ?
If it is easy enough to have the user change his date settings, that would be ideal. But then check that all the legacy dates have changed. If not, you may still need to do a data transformation on the existing dates into the new date format.
Is is this a client server solution?
Yes indeed, this is the problem
All the Text calculations including dates won't be set automatically!
No he is not using a server solution
with dates and times... odd things can happen... sometimes the only solution is to save a clone of the database, open it and import the records from the old one.