Changing date format to dd/MM/yyyy

(0) Share

Report

Posted on by Skyi

Hi,

I have been reading a few forum on changing date format from my planner task.

I still unable to figure how do I do it or in which step I have to change? Please help me.

How to change date format

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

zilu Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

We could use the Text function to do so as specified in https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-datevalue-timevalue

For example: Text( DateValue( Startdate.Text ), DateTimeFormat.LongDate )

The final rendering format will be determined by the device locale.

Please also refer to https://powerusers.microsoft.com/t5/Building-Power-Apps/Date-Format/td-p/144772

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Google is your friend, so is Bing: https://support.microsoft.com/en-us/help/4534778/how-to-customize-format-date-and-time-values-in-a-flow

use the expression "formatDateTime" as in:

formatDateTime(utcNow(),'dd/MM/yyyy')

or if you want to change the timezone:

convertTimeZone(utcNow(),'UTC','GMT Standard Time','yyyyMMdd')

Replace "utcNow()" with your DateTime field, obviously

Was this reply helpful? Yes No
Skyi 2 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Thanks for your kind reply. I am still confused.

As I have attached a photo of the flow earlier, at which part of the flow I have to put the expression?

I try to create action before the html output, but still failed.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

OK. in the "Start Date" field, rather than picking a value from the Dynamic Content list, switch to "Expression" and start typing the name of the function to be used, eg: format... then pick the "formatDateTime" expression from the list, add the opening bracket, then switch to "Dynamic Content" to select your date/time variable to be formatted. This will get inserted into the expression. Then add the rest of the expression parameters, ie: the desire format string.

Using "Expression" window and switching between it and the Dynamic Content window can sometime be fiddly, but it works. You can type in the whole expression *into the expression box* provided you get it 100% correct, then press OK and it will be inserted in the flow. You *cannot* just type an expression directly into a flow field!

For example, you could type this... formatDateTime(utcNow(),'dd/MM/yyyy')
into the box highlighted below, press OK and it would work. It will then appear in the flow field with a (sort of) red [fx] label

Good Luck

Was this reply helpful? Yes No