Formula

[JACKIEC1992]

How do I change the date from Jan 2021 to "01/01/2021" format?

[DataNath · Accepted 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')

[JACKIEC1992]

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

[DataNath · Accepted solution]

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.

[JACKIEC1992]

Good morning,

I have another formula question. How would I convert this for the transaction dates to the same format?

[binuacs]

@JACKIEC1992 one way of doing this