Unable to Update Date

[Anonymous]

Hi All, 

Please help!

I have set up a sharepoint list using an existing excel file. After having some problems in trying to get dates to work, I managed it using 

addDays('1899-12-30',int(item()['Created']),'yyyy-MM-dd')

HOWEVER, now I am unable to update this Date field using a seperate excel file I will want to use every day to update the data.

I have checked all variables and I have no problems updating any of the other fields, and I can create new items with the date field no problem, I just CANNOT update the date field and it is driving me crazy. 

I am getting the following error (sorry for the German but hoping someone can help anyway)

InvalidTemplate. Vorlagensprachausdrücke in den Eingaben der Aktion "Element_aktualisieren" in Zeile "1" und Spalte "24932" können nicht verarbeitet werden: Die Vorlagensprachfunktion "int" wurde mit einem ungültigen Parameter aufgerufen. Der Wert kann nicht in den Zieltyp konvertiert werden..

Details of my flow, with the error, below:

I have no idea why I can create dates, I can update all other fields but I can't update the date field.

Please help!

[PrasadAthalye · Accepted solution]

@Anonymous instead of yyyy-mm-dd use the format .. see if it helps...

yyyy-MM-ddTHH:mm:ssZ

Like and Mark this as answer if it resolves your issue.

[askondo]

@PrasadAthalye Thank you for always activating the forum and for your responses.