Solved! Go to Solution.
How about if you want to end up with February?
Hi,
Then it is:
DateTimeFormat([Field1],"%B")
Best regards,
Daniel
I totally missed that in the help section. So used to MMMM in excel. Thanks.
here is the full datetime functions reference to play with :)
http://help.alteryx.com/9.5/Reference/DateTimeFunctions.htm
Have fun and Happy Data Blending!!!
the datetimeformat function is not working
it is telling orderdate is not a valid datetime
pls help me to solve this......
Hi,
This works with the regular formula tool, but not In-database. Could you tell me how to extract month with the In-database formula tool?
Thanks,
Parvathy
What if you're trying to get the month# as int36 so that you can then multiply it with another #? I am trying to populate last month's # to then multiply it with a quota to get YTD quota. Every time I get an error because it is vstring.