FileKraft

File Date Format Settings issue

Discussion created by FileKraft on Sep 27, 2017
Latest reply on Sep 28, 2017 by beverly

In FMP16v2 and earlier the date field on a layout if swapping day month depending of calculation it is involved.

GetNthRecord  returns swapped dates in portals etc.

 

Here is a file with a minimal example where a date field calculation is referenced in a placeholder on a layout.

the same date field is part of a text concatenation and swapped day and month.

 

the first placeHolder calculation does:

 

Date ( Month ( MonthAccount::MyDateField ) ; Day ( MonthAccount::MyDateField ); Year ( MonthAccount::MyDateField) )

 

the second does:

 

"some text here " & Date ( Month ( MonthAccount::MyDateField ) ; Day ( MonthAccount::MyDateField ); Year ( MonthAccount::MyDateField) )

 

to replicate you need to create a file with file settings from a DD/MM/YYYY then use system settings with MM/DD/YYYY.

 

i attach the file.

this has been an issue for years and makes it difficult to do date math because you never know which operation flips DD with MM ..

 

thanks.

Attachments

Outcomes