Answered

DateTimeFormat

(0) Share

Report

Posted on by Gayu

Hello all ,

In the above image ,From should be the yesterday date and To should be the current date . The date field Dropdown has value 1 , 2 , 3 etc. So It wont access the value from the date drop down box when I use the below Action to get the current date value. It takes only the value as 01, 02 , 03 . Any advice?

Categories:

Power Automate Desktop

All responses (7)

Answers (2)

Sort by

VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Gayu

What happens when you use only a single d?
Gayu 46 on at

Like
a
(0)

Report
Copy link

Link copied!

when am using a sing 'd' it returns the entire date format like (4/5/2022). And when am running it , It shows an error message like this.
Verified answer

VJR 7,635 on at

Like
a
(2)

Report
Copy link

Link copied!

okay then if there is no inbuilt formatting available then you can do something like this

wscript.Echo(day("%CurrentDateTime%"))
Verified answer

VJR 7,635 on at

Like
a
(1)

Report
Copy link

Link copied!

okay then if there is no inbuilt formatting available then you can do something like this

wscript.Echo(day("%CurrentDateTime%"))
Gayu 46 on at

Like
a
(0)

Report
Copy link

Link copied!

Ok I will try this , But what happen if the date is two digit value i.e. 10, 11, 12 like this?
VJR 7,635 on at

Like
a
(1)

Report
Copy link

Link copied!

The vbscript Day function returns a number between 1 and 31 that represents the day of the month.
Gayu 46 on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks for given the Right Solution.