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!