dates..

[elvis_impersonating_penguin]

ok.. in my filemaker database i have a field that just autoenters the creation date when i new record is created... and i formated so it displays like this: January 2, 2001. However, when i display it in a web browser using webcompanion it reverts back to 1/2/2001. is there anyway to make it display the as January 2, 2001 in the web browser?:

[Anatoli]

IMHO use calculation field with date converted to text, that will display correctly in the same manner.

[Simonpennington]

You put [fmp-field: date_created, format]

and it should look the same as in filemaker

Simon

[elvis_impersonating_penguin]

well i was not able to get either one of those to work.. its not too important though.

[tomrt]

Bman,

Use a calculation field. The following calculation changes a date field (named "date") to the format like Wednesday, January 3, 2001...

If(DayofWeek(date) = 1, "Sunday", If(DayofWeek(date) = 2, "Monday", If(DayofWeek(date) = 3, "Tuesday", If(DayofWeek(date) = 4, "Wednesday", If(DayofWeek(date) = 5, "Thursday", If(DayofWeek(date) = 6, "Friday", If(DayofWeek(date) = 7, "Saturday", "")))))))

& ", " & MonthName(date) & " " & Day(date) & ", " & Year(date)

-tomrt