If you add an item in a list containing date-time field but to leave the date blank what will that column contain? Is it null,or empty string or something else?


I have tried to create a workflow and set a workflow variable to that date field and log it to the workflow history but i get following outcome

enter image description here

enter image description here

If this is the case then how to check if a date-time field is empty or not in workflow?


To check if a date-time field is empty or not just create a workflow variable of type Date-time call it say "Empty" and than in the if condition check with this variable

| improve this answer | |

The default value (default constraint in SQL Server) is stored in the database only when the column is not specified in an INSERT statement. If datetime2 value '001-01-01 00:00:00' is being stored, that means the application is including the datetime2 column in the insert statement and passing either an empty string or a DateTime instance without an assigned value.

May be you need something like in this solution - check for equality with '01.01.0001 5:30:00'

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.