qRules DateDiff - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

qRules DateDiff

Last post 04-14-2016 03:46 PM by Hilary Stoupa. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 04-14-2016 03:07 PM

    qRules DateDiff

     I need to find the number of days between today and InfoPath field:   EndDate

    I have tried every DateDiff command syntax I can think of after reading thru the documentation but I just can't get it right:

    DateDiff /date1=/my:myFields/my:group1/my:group2/my:EndDate /date2=Today() /component=days

     I have set a rule: Set fields value:  COMMAND         with the above in the value. 

     In preview, the ERROR field shows:  "The first date is invalid."

     

    What am I missing?

     

  • 04-14-2016 03:46 PM In reply to

    You need to use a concat formula. In the formula editor:

    concat("DateDiff /date1=", EndDate, " /date2=", today()," /component=days") 

    Hilary Stoupa

Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.