How do I include an excel date in Sharepoint. I've visited other threads, but without success.

[leofigueiredo]

Hi, I'm trying to get a date from excel and insert it into Sharepoint, but the following error appears.

That's the expression I'm trying to put. I've tried several other expressions from other forums, but without success.

if(equals(items('Apply_to_each')?['Request_Date'], 'null'), " '', addDays('1899-12-30', int(items('Apply_to_each')?['Request_Date']), 'MM/dd/yyyy'))

If I insert "float" in the expression, it gives an error, if I insert "int", it also gives an error

I've tried before:

if(equals(item()?['Request_Date'],''),null, item()?['Request_Date'])

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

if(equals(item()?['Request_Date'],''),null, addSeconds('1899-12-30',int(formatNumber(mul(float(item('Apply_to_each')?['Request_Date']),86400),'0','en-us')),'yyyy-MM-dd HH:mm:ss'

[Rhiassuring · Accepted solution]

Hey there, 

Here's what worked for me (just tried & confirmed):

if(empty(items('Apply_to_each_2')?['DueDate']),null, addDays('1899-12-30',int(item()['DueDate']),'yyyy-MM-dd'))