Compare / Test Blank Dates in SharePoint Designer workflow

Missionem: In SharePoint Designer workflow, you need to determine if a date field is blank.

Forsit: SPD does not provide a direct method for comparing dates to anything other than a date. You cannot create a condition like this: "If [Date Field] equals blank".

Solutio: Convert the date to a string. Use string comparison to determine if the date is blank.

Collaborative offa:

The following screen shots show how to do this. In hoc missione, in agrum item, "Environmental Permits:First Permit Reminder Date", responsio subiiciatur et workflow ignes.

imaginem

imaginem

Notes:

Cum hoc probatum, I was pleasantly surprised to learn that it works. I was worried that SharePoint Designer might disallow the string assignment (INCERTUS:StringReminderDateDate) sed non sinunt,.

Qui etiam de me passurum, pretium fore aut irritum et flare ad WF runtime vel maybe attollere global temperatus 1/2 Gradus, sed erant illis de vano.

</finem>

Technorati Tags:

5 cogitationes on "Compare / Test Blank Dates in SharePoint Designer workflow

  1. Tim

    Quæstiones:
    1) Cum nullum obtestationis supra, it’s not working because the value of a blank date seems to be "?????" (Credo hic valor est transpositis NULL). Cum mihi propono contentis in filum admodum, it shows up as "?????".

    2) Joe – when you wrote "If Field is greater than or equal to Today or Field is less than or equal to Today", do you mean that you can use variables like "Today" in workflows? Si ita, quomodo potestis vos? Ive 'had nullam fortunam experirentur, et ego credidi solum bonis sunt in vacuo possunt.

  2. Joseph
    Cur non temptabis condicionis:
    Vestibulum Si ager maior vel aequalis
    Vestibulum minor vel aequalis agrum
    This would give you an "if field is not blank, hoc faciunt, aliud (ager autem est blank) quod facere"

Leave a Reply to Tim Cancel reply

Tua inscriptio electronica non editis. Velit sunt insignis *