Answered

Swap Date Format from EU to US

(0) Share

Report

Posted on by shun88

Hello,

i have a question or more like a problem i want to change to Date from dd.MM.yyyy to yyyy.dd.MM so from EU to US format with

"formatDateTime" or "convertTimeZone" but everytime i try it is throwing me a Error because of the ISO format.
Additional Information our Environment is in the Region EU.

The Expression for the conversion its this one: @{formatDateTime(triggerBody()['text'],'yyyy.dd.MM')} but seem not to be working are there other method ?

I have the same question (0)

All responses (3)

Answers (1)

jdoss 458 on at

Like (0)

Report

Re: Swap Date Format from EU to US

The "22.3.2023" is a string that is not in the datetime format accepted (ISO). If the time you are trying to convert is stored somewhere (like a created/modified time on a file or list item, when an email was received, or just the current time) then you can use that to convert to another format. But I would need to know more about the time you are trying to convert.

Was this reply helpful? Yes No
shun88 18 on at

Like (0)

Report

Re: Swap Date Format from EU to US

Sure, i extract the date/time from a PDF document with AI Builder and save it as String in sharepoint field.
Since most document are from EU the Date and Time format are also in EU -> dd.MM.yyyy but i need to convert them in yyyy.dd.MM what would be the best way to archive it and there are alot of date in the document like 4-5 Field.

Was this reply helpful? Yes No
Verified answer

jdoss 458 on at

Like (0)

Report

Re: Swap Date Format from EU to US

So, if the dates will always be like that then you can parse them with an expression.
@{join(reverse(split(outputs('Compose'), '.')), '-')}
Which will reverse them and create an acceptable ISO string. Then you can use, Convert time zone to get it in whatever format you want.

1 people found this reply helpful.

Was this reply helpful? Yes No