Hello, and welcome!
To convert your field to a proper date with CtoD, you need the month, day and year.
Embed a day in your date, like this:
This will give you the first of the month. This is how I deal with my fiscal periods, because the final reports never show the day number anyway.
Hi and welcome to the forum.
You will need to add a dd to make the string a date, assuming you can choose a dd to use.
should work under normal circumstances. dd would be a day in the month.
So if dd was entered as 01 and mmm-yyyy existed as JUN-2008 the above formula would concatenate 01- with JUN-2008 giving 01-JUN-2008 as a string of text.
CtoD will then convert that to a value that can be displayed in a field defined as date format.
Is that what you need to achieve?
Edit: Or Kruncher's solution of course if you need the m/d/y format as a starting point .. overlap postings! :rolleyes: