I am using the function following to convert date value in Excel and migrate them to SharePoint list . But it doesn't work with error message .Could you please help on it? Thanks a lot.

(0) Share

Report

Posted on by GUOGUO

389

Dear all

I am using the function following to convert date value in Excel and migrate them to SharePoint list . But it doesn't work with error message .Could you please help on it? Thanks a lot.

formatDateTime(addDays('1900-01-01', add(int(items('Apply_to_each')?['Opened']), -2)), 'yyyy-MM-dd')

All responses (1)

Answers (1)

Verified answer

fchopo 7,968 Super User 2025 Season 1 on at

Like (1)

Report

Re: I am using the function following to convert date value in Excel and migrate them to SharePoint list . But it doesn't work with error message .Could you please help on it? Thanks a lot.

Hi @GUOGUO

You could try to get Excel dates in ISO-8601 format, so you don't need to do any conversion:

Another possible issue would be that date value is null, so when you apply the int function, it gives you an error.

I would recommend using the first approach.

Hope it helps!

Ferran