Format Date dd/mm/yyyy in objet field

[jgayoso]

If I enter the date 02/13/2018 the validation gives OK, but if I enter 13/02/2018 the validation is invalid date.
.
if field "field_date" is not date then
answer "fecha invalida"
else
answer "Fecha OK"
end if

How do I enter DD / MM / YYYYY and validate OK?

Thank you for any help.

Jorge Gayoso
Chile

[SparkOut]

If your regional settings are set for DD/MM/YYYY format then you can

Code: Select all

set the useSystemDate to true

This will need to be reset for each script that uses date functions and will unset itself at the end of the script. On Windows, please note that a date before 01/01/1970 will not validate at all, regardless of the system date settings.

[dunbarx]

What Sparkout said.

Just for grins, know that on a Mac (of course) a wider range of prehistory is available.

viewtopic.php?f=9&t=26619&p=138530&hili ... ng#p138530

Craig Newman

[bogs]

On Windows, please note that a date before 01/01/1970 will not validate at all, regardless of the system date settings.

couldn't you just grab the seconds since then, and convert it to date?

*Edit - On reflecting about it a bit more, I think I'd use the date function, then put the items in whatever order I needed them to show up.

[jgayoso]

SparkOut , thank you.

Greetings from the south of the world.

Jorge Gayoso