How do I change the date from Jan 2021 to "01/01/2021" format?
Solved! Go to Solution.
Hey @JACKIEC1992 - should just be able to use the following formula (just replace [Input] with your field - [Month]):
DateTimeFormat(DateTimeParse([Input],'%b %Y'),'%d/%m/%Y')
Great, thank you - One more how do I return a number based on an expression. For example, I want to return 41012 if the expression is "AJE (revenue 41021) or "24003" if the expression is AJE (deferred revenue 24003)
Thanks
No problem @JACKIEC1992. For the additional requirement, will that field always be in a similar format and you just want to extract the number/code? If so, you could use something like this which will just replace anything that isn't a number with nothing and so is the equivalent of simply extracting that:
REGEX_Replace([F1], '\D+', '')
Simple edit to the formula as there's no need for the \D+ to be bracketed as a capture group.
Good morning,
I have another formula question. How would I convert this for the transaction dates to the same format?