How to delete a datetime value ?

associationp157

07-03-2018

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

Accepted Solutions (1)

Accepted Solutions (1)

Amit_Kumar

MVP

09-03-2018

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

1438621_pastedImage_0.png

Regards,

Amit

Answers (0)