DateDiff Output when less than 1 day - InfoPath Dev
in

InfoPath Dev

DateDiff Output when less than 1 day

Last post 05-29-2013 11:47 AM by Deeayrian. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 05-29-2013 08:50 AM

    DateDiff Output when less than 1 day

    I am using the qRules DateDiff function to calculate weekdays a form stays open.  If the form gets closed within the same day it is created, the output is blank.  Is there a way I can have it output something, even if it is 1, for situations when the form gets closed within the same day?

    Filed under:
  • 05-29-2013 11:33 AM In reply to

    Re: DateDiff Output when less than 1 day

    Hi-

    I guess one option is to have a rule, with the condition Result is blank, which does whatever is needed in this scenario.

    If DateDiff outputs 1 in this scenario, it's an incorrect calculation. :) So I think you'll have to let DateDiff do it's calculation and just have rules afterwards (with conditions) for the two options (when there is a result and when there's no diff).

    Hope this helps!

    Ernesto Machado
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™


  • 05-29-2013 11:47 AM In reply to

    Re: DateDiff Output when less than 1 day

    Thank you Ernesto.  I will create a workflow to run on the list to accommodate for this situation. :)
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.