Saturday, 14 September 2013

Sharepoint Designer Workflow - Empty Date field value

Hi All,
 Today we will see a peculiar behaviour of Sharepoint Date Field in Designer Workflow.

ok,, lets consider this scenario. There is a list with a DateTime column(Say, "Publishing Date") and that is a not a mandatory field.
My requirement is to get the value of the "Publishing date" in mail..
I retrieved the value and showed that in mail..

Now the problem comes,,,

1) If the "Publishing Date" is filled , then it is well and good. It is also shown in the mail.
2) If "Publishing Date" is not filled and left empty in SharePoint then the mail is showing "1/1/0001" in that area.

   Note : No exception comes, No blank field comes in that area of the mail.

So obviously my requirement was to show a blank space when the "Publishing Date" is empty...

Workaround for this is shown in the below image.. this is done by adding a WorkFlow Variable- "stored variable" and setting its value to an blank (i.e) "one empty space" in its value assigning area.



Its doneee... Thank you.. See u all on next post...

No comments:

Post a Comment