Convert date to written out version of date
The date field has an option to spell out the month. However, it abbreviates the month to the first three letters and is in all caps. I need an options that spells out the ENTIRE month, and formats it...
Forum Discussion
you can make a text field like this and adjust the names of the months.
var date MyDate = [... insert your date field here ...];
List("-",
Case(Month($MyDate),
1,"Jan",
2,"Feb",
3,"Mar",
4,"Apr",
5,"May",
6,"Jun",
7,"Jul",
8,"Aug",
9,"Sep",
10,"Oct",
11,"Nov",
12,"Dec"),
Right("0" & ToText(Day($MyDate)),2),
ToText(Year($MyDate)))
var date MyDate = [... insert your date field here ...];
List("-",
Case(Month($MyDate),
1,"Jan",
2,"Feb",
3,"Mar",
4,"Apr",
5,"May",
6,"Jun",
7,"Jul",
8,"Aug",
9,"Sep",
10,"Oct",
11,"Nov",
12,"Dec"),
Right("0" & ToText(Day($MyDate)),2),
ToText(Year($MyDate)))
- thanks so much. I am a bit frustrated because I am going to have to do this across the entire app, over 50 different date fields. Definitely not the best solution but better than not having it at all. thanks again!