Posted by: JB | Date: 02/16/2017 19:08 | IP: IP Logged
I am trying to figure out how to set the "Edit-Insert date & time" to use the USA date format (mm/dd/yyyy).
I set the date time format (Edit-Date Time Dialog) to dd/mm/yyyy hh:nn:ss but when the date is inserted it is still in mm/dd/yyyy format.
What am I doing wrong?
Edited 1 time(s). Last edit at 02/16/2017 19:33 by Stefan.
Posted by: pspad | Date: 02/16/2017 20:11 | IP: IP Logged
Select format you want to use and then you can insert with Insert date time with selected format.
If you want to insert date time e.g. in code clips using %date% or %datetime% variable, you need to set correct format in menu Settings / Variables
Posted by: JB | Date: 02/17/2017 17:49 | IP: IP Logged
Thanks for the response, however, the problem is that there is no default format in USA date format (MM/DD/YYYY). Is it not possible to change or add a new format?
Edited 1 time(s). Last edit at 02/17/2017 17:50 by JB.
Posted by: vbr | Date: 02/17/2017 20:00 | IP: IP Logged
I can confirm some strange behaviour with regard to slash / (solidus) character in the date - time format
slash / seems to be replaced with full stop . somehow (even in the preview area of the Date Time Dialog,
i.e. if I insert the following into the edit field:
the preview area above shows instantly e.g.:
and in this format it is also saved to the list (after clicking Add or Replace), and this format is also used later with "Insert date and time".
Posted by: pspad | Date: 02/17/2017 20:50 | IP: IP Logged
I can confirm and I will fix it.
Posted by: pspad | Date: 02/20/2017 17:18 | IP: IP Logged
I found reason - system function replaces "/" (standard date delimiter) with date delimiter from regional settings
Posted by: JB | Date: 02/24/2017 15:51 | IP: IP Logged
I guess I got confused and forgot to change the date format from dd/mm/yyyy to mm/dd/yyyy (the US format). It is actually working fine now that I figured that out. A good night's sleep works wonders.