Hey all,
Quick question (hopefully) that I've been unable to locate in any google search. I'm trying to set a calculated auto-entry value for a text field that should contain the date in long form based on the date entered in another field. Ie:
DateField: 9/5/2008
Calculated field: "September 5, 2008"
The date format on the date field is set to the proper form, but when I use "Month ( DateField ) & " " & Day ( DateField ) & ", " & Year (DateField)", it returns the numeric value (ie. 9 5, 2008") rather than the full form.
How do I force it to return the spelled out month?
Thanks!
-Sitryd
Quick question (hopefully) that I've been unable to locate in any google search. I'm trying to set a calculated auto-entry value for a text field that should contain the date in long form based on the date entered in another field. Ie:
DateField: 9/5/2008
Calculated field: "September 5, 2008"
The date format on the date field is set to the proper form, but when I use "Month ( DateField ) & " " & Day ( DateField ) & ", " & Year (DateField)", it returns the numeric value (ie. 9 5, 2008") rather than the full form.
How do I force it to return the spelled out month?
Thanks!
-Sitryd