DayOfWeek Problem

[MartinaL]

I am having an issue with the DayOfWeekName function.

I have a field set to show the day of the week name with the following formula - DayOfWeekName(gdTempDate), gdTempDate is the 01/09/2007 which is a Saturday and the field is returing Sunday?

[Vaughan]

It depends on where you are -- 01/10/2007 could either be January 10 or October 1. Look at your OS region or language settings.

The gdTempDate field needs to be of type date, not text.

September is the 9th month of the year.

[MartinaL]

I know, i wrote 01/10/2007 to start with then updated the post because it is actually the 1st of September that I am having a problem with.

OS settings are set correctly for Australia so dd/mm/yyyy

[MartinaL]

And gdTempDate is set to type Date

[Vaughan]

Foe FMP 6 the calc should be

DayName( gdTempDate )

As a test, change the calc to

DayName( Date( 9, 1, 2007 ) )

to hard-code 1 September 2007 into the function and see what it comes up with.

Only other suggestion is to make sure you're running FMP 6.0v4 and not an earlier buggy version.