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!

Outcomes