@Jeff_Hager I just had an epiphany!
In my apps, I have lots of columns that look like this:
As I was creating yet another one of these yesterday I was thinking to myself “there must be an easier way”. And then it hit me just now as I was reading your post…
Challenge: Extract the short month name from a date (eg. “Jan”)
The way I normally do this is by first extracting the Month and Day components using date math, and then that stupid if-then-else column to determine the month name.
But there is a much easier way…
- Create a Text column that contains all the month names
- Then do a direct lookup on this column with a Single Value, using the calculated month number as an offset from the start.
Soooooo much easier!! 