A text field contains invalid data

[sudheermadduru1]

Hi,

I have a field called ApprovalDate2.

ApprovalDate2 column is of type single line of text.

I am updating the above field with todays date in the update item action as below 

formatDateTime(utcNow(),'MM-dd-yyyy')

But I am getting the error as below. Please let me know if I am making any mistake

'A text field contains invalid data. Please check the value and try again.'

Regards,

Sudheer

[abm]

Hi @sudheermadduru1 

FormatDateTime returns a string value so that should work as expected.  Are you sure this error is related to ApprovalDate2 formatDateTime() value? Try also formatting without the hyphens.  

formatDateTime(utcNow(),'MMddyyyy')

I am not suggesting to remove hyphens as a suggested solution but lets see what error you get?

Thanks