Date formatting - formula

[Redzapplin]

Hi all, 

I wanted to convert my date to month and year with an extra zero.

if my date i 27-02-2020 then my calculation should say 002.2020

or if my date says 30-12-2020 then calculation should say 012.2020.. I want to use it in my date prompt

any leads using regex or anything will help. thanks

[RolandSchubert]

Hi @Redzapplin ,

you'll ave to convert the date to a date data type and format the date to get the result you need. 

The formula:

DateTimeFormat(DateTimeParse([Field1], '%d-%m-%Y'), '0%m.%Y') 

should do the job.

Hope this is helpful.

Best,

Roland

[Redzapplin]

Hi @RolandSchubert,

I am getting a null. Ideally I am looking for something that I have attached  

[RolandSchubert]

Do you want to select a date using the Date tool and convert this date to the format '0mm.yyyy'? Or is the a comparison of dates (input against the selected date)?

[Redzapplin]

Exactly!

Sorry for the confusion.

[RolandSchubert · Accepted solution]

I think, this should work. 

Select a date:

The result will be:

Let m know, if it works for you.

Best,

Roland

[Redzapplin]

@RolandSchubert  You are "AWESOME"