AnsweredAssumed Answered

«substitute (date ; "/" ; ".") doesn't work in FM16

Question asked by softools on Dec 15, 2017
Latest reply on Dec 18, 2017 by softools

Since .fp7 in Swiss German OSX Systems there is a bug in the date format.

«Get System Date» in a script or «Command -» resulted in a wrong date format dd/mm/yyyy instead dd.mm.yyyy

This could be fixed with the «substitute (date ; "/" ; ".")» step and somehow by formatting the date field (but in this case if you enter the field these slashes are back again).

Unfortunately it's no longer possible to use «substitute (date ; "/" ; ".")» in FM16 in a date field (it still works in a text field) in databases created in previous versions and opened in FM16.

Except if the database is created in FM16 and not moved to High Sierra

Outcomes