kylerjphillips

Replace Date fields with correct format DD/MM/YYYY

Discussion created by kylerjphillips on Mar 16, 2016
Latest reply on Mar 16, 2016 by disabled_morkus

Currently - I have a few users in my database that are entering dates in the following format DD.MM.YYYY - FileMaker understands that this is a date however, I would like to create a script and also a Replace Field Contents with it in the following format DD/MM/YYYY - with the slashes.

 

The reason is I have problems importing this to SQL when the format is in dots(.), hypens(-).

 

Ideally, if I could convert all dates to DD/MM/YYYY that would be great.

Outcomes