Did you try:
Zone1+Zone2+str(year([Delivery Date])+str(month([Delivery Date])+str(day(Delivery Date])
This solution is perfect, however it returns:
20142 for Feb 2014 instead of 201402. I have currently hard coded a 0 into the string concatenation, but is there a more elegant solution, of simply modifying the MONTH function to display in mm format instead of an integer?
I have already tried this:
1) I duplicated my Delivery Date field
2) I changed it's data type to Date
3) I changed it's display format to YYYYMM
When I concatenate Delivery Date (copy) to Zone1 and Zone2 strings, it simply returns the incorrect result as mentioned above in my first post. Perhaps I am missing a step?
you may need to plug in the STR(month([date field])) in order to get the 2-digit month. What is your current formula?
[Zone1 Id] + [Zone2 Id] + STR(YEAR([Delivery Date])) + STR(0) + STR(MONTH([Delivery Date])) - Ignore the hardcoded 0...
it should return:
1 of 1 people found this helpful
you could create a new calculated field for the month called "delivery date month", refer to this calculation in place of the month portion of the previous calc.
if len(str(month([delivery date month]))=1
then "0"+str(month([delivery date month])
else str(month([delivery date month])
Yup at this time, i'll have to say Vinnie has a decent fix to go along with all of it.