Unanswered

Date Time format in PVA

(0) Share

Report

Posted on by R_KW

Hi,

I am having a date time variable in PVA, but it only read in MM/DD/YY, and I want to change it to read DD/MM/YY, how can I do that?

For example, user input 10/9/2021, PVA read as 9 October 2021, but I want it to be 10 September 2021.

I will use the PVA to check whether the user input date is before or after the cutoff date.

Thanks!

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Sort by

CU22081450-0 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @R_KW ,

You'll need to validate it using a Power Automate workflow.

Follow below three links related to the formatting date value using a flow, but if you have any questions, let us know:

Solved: Re: Formatting Date And time in MS Flow - Power Platform Community (microsoft.com)

Solved: How to change Flow date from YYYY-DD-MM to DD-MM-Y... - Power Platform Community (microsoft.com)

How to customize/format Date and Time values in a flow (microsoft.com)

Was this reply helpful? Yes No
R_KW 80 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the response @renatoromao ,
I tried to use "formatdatetime()" but it seems just changing the way to show the date, but not changing the way to read the date.
For example, formatdatetime(10/9/2021, 'dd/mm/yyyy'), it just return 9/10/2021 (9 Oct 2021), but what I really want is 10/9/2021 (10 Sept 2021).

Was this reply helpful? Yes No
Jcook 7,781 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @R_KW

For defining the date format,

dd = day

MM = Month

yyyy = year

Check out my post on formatting date:

https://flowaltdelete.ca/2020/10/15/converting-time-zones-easily-in-power-automate/

Was this reply helpful? Yes No
cabata 314 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

hi @R_KW also if you want in a expression you can use this: How to get a date in "MM/dd/yyyy" format in Microsoft Power Automate - YouTube

Was this reply helpful? Yes No