Contents
You have three options to check if the current date field value is NULL or Empty in SharePoint Designer Workflow:
- Create a new hidden Date field with a null value.
- Perform if condition with 01/01/0001.
- Create a null date variable.
How do you make a date field empty?
“NULL” can be specified as a value in the Date field to get an empty/blank by using INSERT statement. Example: CREATE table test1 (col1 date); INSERT into test1 values (NULL);
General questions about SharePoint 2013 can be answered here: http://social.technet.microsoft.com/Forums/en-US/sharepointgeneral and for versions prior to 2010 here: http://social.technet.microsoft.com/Forums/en-US/sharepointgenerallegacy 5 1 I want to initialize/set a string variable to null/empty at the start of the workflow.
How to enter null value into date column?
In the flow, create a condition that checks the Form value – If blank, set a variable ‘DateVariable’ equal to a string value of ‘Null’; If not blank, set ‘DateVariable’ equal to the Form’s date value 3. Use the following equation on the Create SharePoint Item for the date field: 09-12-2020 04:56 AM I figured out a solution… For future reference…
How to create null value in SharePoint list?
1. Create a variable called ‘Null’ and set it to a string value of ‘Null’ 2. In the flow, create a condition that checks the Form value – If blank, set a variable ‘DateVariable’ equal to a string value of ‘Null’; If not blank, set ‘DateVariable’ equal to the Form’s date value
How to check if date column is blank?
Here is how i check if Date column `Col` is blank: Any correct solution? Solved! Go to Solution. 07-15-2019 07:27 AM This was later added as a feature whereby you can set the value of the item to blank either by having a blank textbox or etc that pushes to the source or by using Blank ()