Forum Discussion
- Please give an example of a date and the result that you want to achieve. For example, today is March 13, 2018. What is the text result you are looking for?
- I want 3-13-2018 to read "March
Not sure why it didn't post the rest but I'm trying to transfer the numeric date into another field, isolating the month as a word instead of a number. I scrolled through several pages in the forum and didn't see a way to do this so I apologize if it's somewhere else.
Thanks!
- Try this
Case(Month([my date field goes here]),
1, "January",
2, "February",
3, "March",
4, "April",
5, "May",
6, "June",
7, "July",
8,"August",
9,"September",
10,"October",
11,"November",
12,"December") - That worked! Thank you so much!!
