AnsweredAssumed Answered

Date format keeps switching...

Question asked by guit4eva on Oct 31, 2017
Latest reply on Nov 1, 2017 by beverly

Hey guys,


I have a very peculiar problem:


I have to databases: UI and DATA (separation model). In my DATA db I have a timestamp field (Modification_Date).


I have the following script, which has the following results:


Show Custom Dialogue [Globals::Modification_Date] //results in "10/01/2017" <- Correct format

Set Field [mod_date; Globals::Modification_Date] //results in "01/10/2017" <- Wrong format


Why on earth does the date format change when I use set field? The field is set to "as entered" for the data entry, and the Globals::Modification_Date shows as "10/01/2017" when I place it directly onto the same layout as the mod_date field.


Any clues as to what is going on here? I've spent hours trying to figure it out - absolutely perplexed!