Unanswered

Apply to each - using addDays to convert serial number to date

(0) Share

Report

Posted on by jed76

Can anyone help before I throw my laptop out of the window.

I have a very simple flow which LIST ROWS PRESENT IN A TABLE and applies a simple filter. The resultant date which is being produced is an excel serial number and I need to convert it into a date to send via an email. I have tried

addDays('12-30-1899',int(items(‘Apply_to_each’)?['Start date of request_x002e_']),'dd/MM/yyyy')

where 'Start date of request_x002e_ is the name of the column but I keep getting INVALID expression.

I can't believe that doing something so simple is creating such a headache. I just want the date in a DATE format!

Many thanks.

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@jed76 Go to advance option in list row present in a table then select date format Iso.

After that you do not need such conversion

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
Cayshin 332 on at

Like (0)

Report
Copy link

Link copied!

Just want to add a little visual of what Hardesh15 is referencing:

Was this reply helpful? Yes No
jed76 on at

Like (0)

Report
Copy link

Link copied!

I’ve done this but it’s still delivering the date format as “44000” etc.?

Was this reply helpful? Yes No
Cayshin 332 on at

Like (0)

Report
Copy link

Link copied!

If the above isn't working for you, then try this expression to convert it. It's very similar to the one you originally tried.

addseconds('1899-12-30',int(formatnumber(mul(float(items(‘Apply_to_each’)?['Start date of request_x002e_']),86400),'0')))

Was this reply helpful? Yes No
jed76 on at

Like (0)

Report
Copy link

Link copied!

@Cayshin many thanks. Where does this code actually go? I have tried entering it as an expression in the send email field and I still get INVALID expression?

Was this reply helpful? Yes No