qRules DateDiff

Use our Google Custom Search for best site search results.

Last post 04-14-2016 03:46 PM by Hilary Stoupa. 1 replies.

Page 1 of 1 (2 items)
	Sort Posts: Previous Next

Reply Contact

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?

Mark as Not Answer Mark as Answer ...

Reply Contact

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)