Convert time stamp to european time format

(0) Share

Report

Posted on by SveinT83

i am seting up an SMS remainder from Outlook calendar, to my customers.

Im converting timezone whitout problem, but the time is showing like this: "12/16/2019 8:00 AM"

i need it to be convertet to: "16/12/2019 08:00"

Can any help?

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (1)

Pstork1 68,898 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
You can use a custom format string with your converted date time to format it the way you want. Here's an example

formatDateTime(utcNow(),'dd-MM-yyyy H:mm:ss')

Was this reply helpful? Yes No
SveinT83 14 on at

Like (0)

Report
Copy link

Link copied!

Thanks. Can i chanche the "utcnow" to what i hawe in the calendar? i the calendar event is in the futore, this output shows todays date and time.

Was this reply helpful? Yes No
Pstork1 68,898 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Yes, you should be able to just substitute the date time string you are generating for the UTCNow(). That was just a quick example to test that it works.

Was this reply helpful? Yes No
SveinT83 14 on at

Like (0)

Report
Copy link

Link copied!

I dont understand what to change "UTCnow" to, in order to format the time.

I did try:
formatDateTime(Test(),'dd-MM-yyyy H:mm:ss

Was this reply helpful? Yes No
Verified answer

SveinT83 14 on at

Like (0)

Report
Copy link

Link copied!

I got the suluton 🙂

In an "Compose" i put this code: "@formatdatetime (body('tf'),'dd-MM-yyyy hh:mm' )"

Was this reply helpful? Yes No
Pstork1 68,898 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

You can just use the Enter Custom Value in the time string of the Convert timezone action and paste in the custom format string there. That will automatically do the formatting when you convert. Then you won't need an extra compose or FormatDateTime function.

Was this reply helpful? Yes No