Hi guys, little help for a beginnner
I have a field with string datatype like this
Month
1
2
3
...
I want a new field where 1 is Jan, 2, is Feb and so on
Could help?
Solved! Go to Solution.
Hey @AnGi
I'd go for something like this:
DateTimeFormat("2020-"+PadLeft(ToString([Field1]),2,"0")+"-01", "%b")
I would also recommend that you bookmark this page as its super helpful:
https://help.alteryx.com/10.1/Reference/DateTimeFunctions.htm
Hi @AnGi , I hope this helps.
Thanks.
Formula Used:
datetimeformat("2020-"+padleft(tostring([Month]),2,"0")+"-01","%B")
Hi @atefehhez
I think that you made some confusion with your browse tabs, here is the right link to post the challenge 193 solution:
https://community.alteryx.com/t5/Weekly-Challenge/Challenge-193-Unofficial-Holidays/td-p/500029