Answered

AddDays after using addDays to covert excel date (integer) to ISO 8601

(0) Share

Report

Posted on by HunterM1

Ok, perhaps there is a much easier way to do this such as creating creating a variable or composing an output, but I am curious if there is a way to use addDays to add 3 days to a particular excel date after using addDays to convert said excel date to ISO format?

Something like this:

formatDateTime(addDays( addDays('1899-12-30',int(items('Apply_to_each')?['Excel Date']),'yyyy-MM-dd'), 3), 'yyyy-MM-dd')

I'm sure there is some redundancy in the expression above. Of course if there is a much easier way to handle this that would also be appreciated, but I am still curious if power automate will allow an addDays expression within an addDays expression.

Thanks in advance!

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

CFernandes 8,482 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hey @HunterM1

If you use list rows in the table it give you an option to specify the DateTimeFormat -

Once you have the date is correct format try to use add dates with it.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
Verified answer

HunterM1 27 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your reply!

I had the date time format set to ISO 8601 in the LIst rows present in a table step, but for some reason when I was calling in addDays(items('Apply_to_each')?['Excel Date'], 'yyyy-MM-dd') it was giving me an error. But then I realized I had written the format as 'yyy-MM-dd' so I was missing a 'y' and that explains why I was getting the error that I needed to have my date formatted using ISO 8601.

Thanks again.

Was this reply helpful? Yes No