Outlook to Excel Flow - Output date format is reversed from dd/MM/yyyy to MM/dd/yyyy only for some items!!

[RajaSuper]

Hi All,

I am writing a Flow for Outlook to Excel - When I flag an email in Outlook it is added as a new row in a Excel sheet. I am capturing Date and Subject in that row.

I am using below expression string,

formatDateTime(triggerBody()?['receivedDateTime'],'dd/MM/yyyy')

For some strange reason - When I flag about 20 emails, about 10 emails date s are captured in wroong format, i.e  MM/dd/yyyy (reversed). I peeked in to the code, where Output shows in the correct format i.e dd/MM/yyyy

I could not figure out where is the issue. Kindly advise.

[stan_gifford]

When I read a date field from excel it comes in as a number which is the number of days since 12-30-1899 (30th December 1899).

I am fairly sure that if it is a datetime it comes in as a decimal value (sorry have not needed to decode a datetime).

Anyway, to turn it into a date I use the following

formatDateTime(adddays('12-30-1899',int(variables('Cstart')),'yyyy-MM-dd'),'dd-MM-yyyy')

I am just wondering if you reversed this to get your dates as a number and store that into excel - then it would solve the 'inconsistancy issue'?

There is a forum post to get the days between two dates - https://powerusers.microsoft.com/t5/Building-Flows/Flow-to-calculate-elapsed-days-since-List-item-mo...

Stan