Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Accepted Solutions
Hi,
the reason for the behaviour you experienced is that you already loaded your month_fullnames as a date field formatted as month fullnames. So the proposed solutions using the Date# function didn't find a string to interpret as a date (that's what the #-functions do).
On the other hand this means, that your front end expression
=Month(Date(Month_FullNames,'MMM'))can be abbreviated to
=Month(Month_FullNames)as the formatting date() function is useless in this case, it does not change the underlying numerical value of your Month_FullNames field (Ret_Month).
Using this expression
Date(Date#(SubField('$(MonthNames)',';',MONTH),'MMM'),'MMMM') as Ret_Monthto create your Ret_Month field in the script leads to somewhat weird underlying numerical values:
because you are trying to create a complete date value from only a month field (the year information is missing) and then just formatting it to show month fullnames.
I therefore stick to my proposed solution
Dual(Date(Date#(MONTH,'MM'),'MMMM'), MONTH) as Ret_Monthwhich creates these underlying values:
like one would expect from a real month field.
If you wanted to create the month shortname field in the script, then one solution could be:
Month(Date#(MONTH,'MM')) as Ret_Month_short
hope this helps
regards
Marco
