How to delete a datetime value ?

[associationp157]

Hello

I need to delete a value from a colum which type is datetime

I'm doing it Inside a worflow (update component) because I'm updating other fields

I tried to use the NULL value in my Update compoennt, like I did to erase String value but it does not work.

I have an error message saying that NULL (type: string) does not match with the destination field type (type: datetime).

What should I do in order to delete my dateitme value ?

Thanks for your feedbacks

Corinne

[Amit_Kumar · Accepted solution]

Hi Corinne,

Since DateTime is a value type you cannot assign null to it, but exactly for these cases (absence of a value), You can set a DateTime variable to MinTime but the variable itself cannot be null. To get this MinTime use: ToDateTime() as expression with empty params. which will set your date to 02-01-1900 00:00:00

Regards,

Amit

[chriss45436863]

Interestingly, within Adobe Campaign Standard, if you have a second dateTime field in your custom resource that does have an empty dateTime value, you can enrich this empty field as additional data, and update the destination field with this empty source field.

This may not be possible for bulk data updates, unless you can guarantee that the source field is empty for all records.