AnsweredAssumed Answered

Get(CurrentDate) format issue

Question asked by willrollo on Jul 30, 2012
Latest reply on Jul 31, 2012 by philmodjunk

Title

Get(CurrentDate) format issue

Post

Hi

When I use a basic get(CurrentDate) script, the data in the field is in the format M/D/Y. I want it to be displayed as D/M/Y. This happens even if I have the field properties set up to the 'correct' format.

Points to bear in mind:

My Mac is set to British time and date format.

Field is set to Date

Field properties in Inspector is set to the format I want.

 

Does anyone know of anyway of altering Filemaker's default formats for this sort of thing?I think this may be occurring as the databse was set up originally on a pc/mac with the American date format...

Thank you

Outcomes