SharePoint (2007) Designer Today time is showing 12:00 AM RRS feed

  • Question

  • I have a custom list having Two Columns 'Start Date' and 'Due Date'

    I am using Out of box Workflow in SharePoint Designer  having the below Condition and Actions like


    If Start Date is less than or equal to Today

       and Due Date is less than or equal to Today

    Action :

    Stop the workflow

    for example the current date and time is May 02, 2012 3:53 PM.

    But the in the Condition the Today date is calculating May 02, 2012 12:00 AM. why ???

    how do i get the Today(Automatically).

    Please help if anybody having the Ideas and Answers. I am Using SharePoint Designer 2007.

    ~ Syam Maddi

    Wednesday, May 2, 2012 10:57 PM


  • If you ask for Today as just a Date it will supply today's date with a time of midnight.  Even in a Date only field a time value will still be included.

    Paul Stork SharePoint Server
    MVP Senior Solutions Architect: BlueChip Consulting Group
    Blog: http://dontpapanic.com/blog
    Twitter: Follow @pstork
    Please remember to mark your question as "answered" if this solves your problem.

    Thursday, May 3, 2012 12:36 AM