Answered

Date formatting

(0) Share

Report

Posted on by IKinal

Is there any way to change the formatting that the CurrentDateTime function outputs? The default seems to be to output dates without a leading zero (i.e. April is represented with just '4'). However, my web form that I am trying to automate is strict and requires a leading zero for month and day numbers (i.e. April needs to be represented with '04').

Any insights much appreciated.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (1)

Tejashree_G 43 on at

Like (0)

Report
Copy link

Link copied!

using "get current date and time " action you will get current time and date with dd-MM-yyyy format for ex: today's date is "21-04-2021 and time" like this

Was this reply helpful? Yes No
Tejashree_G 43 on at

Like (0)

Report
Copy link

Link copied!

this is just a example

Was this reply helpful? Yes No
Verified answer

fraenK 2,125 on at

Like (1)

Report
Copy link

Link copied!

https://docs.microsoft.com/en-us/power-automate/desktop-flows/actions-reference/text#convertdatetimetotext

Was this reply helpful? Yes No
IKinal 30 on at

Like (0)

Report
Copy link

Link copied!

Unfortunately, I need just the date, without the time. Even though I selected to retrieve the current date only, it still stores an empty time, just like in your screenshot. In order to get around this, I tried to reconstruct the date manually, but CurrentDateTime.Month returns '4', instead of '04'. My web application is rejecting this.

Was this reply helpful? Yes No
IKinal 30 on at

Like (0)

Report
Copy link

Link copied!

Thanks - that gave me the ability to convert the date into the exact format that I needed.

Was this reply helpful? Yes No
jkb6011 122 on at

Like (0)

Report
Copy link

Link copied!

This should not be considered a solution.

Was this reply helpful? Yes No