Forum Discussion
ukeasyproj
Helper II
Helper IIerror when extracting month from Date
I am trying to create a calculated column that extracts the month of a given date in the following format: 01 02 03 04 05 06 07 08 09 10 11 12 But I get the error above. ...
Sorry, you are right! I used a list of numbers 1..12 in my test, forgot to add back in the Month() function. It should have read
= RIGHT ( "0" & Month( [Start Date] ), 2 )
blopez11
Super User
Super UserWhy not use a date table with monthNum field as you specify above and relate the date table to your StartDate column?
Brian_M
Continued Contributor
Continued ContributorSorry, you are right! I used a list of numbers 1..12 in my test, forgot to add back in the Month() function. It should have read
= RIGHT ( "0" & Month( [Start Date] ), 2 )