I have a process data field of type date. The initial value is "empty" (see attached). During my process the value of this field changes, but at some point I may need to clear its value (i.e. set it back to empty). How can I accomplish this?
I tried setting the value to "01/01/0001", but this still shows as a valid date in our reporting. I need it to be empty/null.
Hi,
You can try using the 'Empty String' Inline function, or try passing the text without quotations "scnull" through the property and this should clear the date value.
Hope this helps.
Regards.
Hi,
I would just like to enquire as to whether any of my suggestions worked as you have not responded to this post.
Regards.
I tried scnull and empty.string, but neither worked. Using 1/1/0001 did not error, but also did not clear the field. Are there any other ways to accomplish this?
I'm trying to clear a value in a SQL table.
Thanks
I never did find a solution to this issue. I wound up modifiying our reporting to handle dates of 01/01/1900 differently.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.