How can I check for an empty date condition in a SharePoint Designer Workflow?
I have a list called "Project" with multiple date fields. I have a calendar called "Project Scheduling" where I want to copy those dates. For every pair of two dates (such as "Construction Start"/"Construction End" and "Design Start"/"Design End") for a single "Project" listitem I want to create one list item in the calendar.
I do this by creating a workflow that triggers on add/change and will push the dates to the calendar if both dates in the pair have a value. To check for null dates I have to first store the string values of the dates in workflow variables because you cannot use the "is empty" condition with a date field. However, when I try to check for "is empty" on the date string values the string returns as not empty and it tries to execute my code for creating the item in the "Project Scheduling" calendar. For some reason that fails even though the string is not empty. I would assume that it would succeed seeing as how there was a value in the date string.