Hi,
Im trying to patch a date and am getting the following error
my settings for date time are here
why am i recieveing this error?

Hi,
Im trying to patch a date and am getting the following error
my settings for date time are here
why am i recieveing this error?
Hi @Anonymous ,
The way I read that error, it's trying to place a Text type into a Data column....and your formula is Text(), so assuming your source column is of type Date, this makes sense.
Perhaps try wrapping it in a DateValue() formula;
'Date Completed': DateValue(Text(........)),
Kind regards,
RT