Page 1 of 1
Format Date dd/mm/yyyy in objet field
Posted: Sat Feb 17, 2018 7:42 pm
by 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
Re: Format Date dd/mm/yyyy in objet field
Posted: Sat Feb 17, 2018 7:54 pm
by SparkOut
If your regional settings are set for DD/MM/YYYY format then you can
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.
Re: Format Date dd/mm/yyyy in objet field
Posted: Sat Feb 17, 2018 10:52 pm
by 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
Re: Format Date dd/mm/yyyy in objet field
Posted: Sat Feb 17, 2018 10:54 pm
by bogs
SparkOut wrote: ↑Sat Feb 17, 2018 7:54 pm
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.
Re: Format Date dd/mm/yyyy in objet field
Posted: Sun Feb 18, 2018 1:22 am
by jgayoso
SparkOut , thank you.
Greetings from the south of the world.
Jorge Gayoso