Answered

Changing the format of the date

(0) Share

Report

Posted on by AB21

Hi !

I have set a convert time zone as the time was an hour out which has now been resolved but now im getting the date format incorrect.

so at the in its mm/dd/yyyy but I want it as dd/mm/yyyy

Screenshot 2020-03-25 at 1.14.25 PM.png

Please help!

I have the same question (0)

All responses (5)

Answers (1)

efialttes 14,756 on at

Like (0)

Report

Re: Changing the format of the date

Hi

Didn't you find any suitable format by playing with 'format string' options?

Hope this helps

Was this reply helpful? Yes No
RobElliott 10,286 Super User 2025 Season 2 on at

Like (1)

Report

Re: Changing the format of the date

@AB21 in the Format string field, scroll down to the bottom of the dropdown list, select custom value and type in dd/MM/yyyy.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Was this reply helpful? Yes No
AB21 on at

Like (0)

Report

Re: Changing the format of the date

Hi @RobElliott

Thank you hat about the time would I need to state a formate for the time in the custom value too? if so what would i have to put if I just want the time to be for example 1:45

Thanks in advance

Was this reply helpful? Yes No
AB21 on at

Like (0)

Report

Re: Changing the format of the date

Hi @efialttes

There isnt a suitable one

I need DD/MM/YYYY with short time

Is this possible as a custom value I know @RobElliott mentioned putting DD/MM/YYYY which works but I also need the short time to go along with it.

Please help!

Was this reply helpful? Yes No
Verified answer

efialttes 14,756 on at

Like (1)

Report
Re: Changing the format of the date

Hi!

My suggestion is, leave 'format string' as

Then use expression based on formatDateTime() on the email body

formatDateTime(body('Converted_time_zone'), 'dd/MM/yyyy H:mm')

All possible formats here

https://docs.microsoft.com/es-es/dotnet/standard/base-types/custom-date-and-time-format-strings

Or, as @RobElliott suggests, in the Format string field, scroll down to the bottom of the dropdown list, select custom value and type in

dd/MM/yyyy H:mm

Havent tested this second approach, but eems easier than mine

Hope this helps

Was this reply helpful? Yes No