locked
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

    Condition:

    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

Answers

  • 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