Date formatting - formula

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

Accepted answers

I think, this should work.

Select a date:

The result will be:

Let m know, if it works for you.

Best,

Roland

DateFormat.yxwz

All comments

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

Hi @RolandSchubert,

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

20190325-DateFormat.yxwz

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)?

Exactly!

Sorry for the confusion.

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703