https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/72989.aspxThu, 15 Dec 2011 17:32:53 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:72989shniggens0https://www.infopathdev.com:443/forums/thread/72989.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=72989<p>That worked perfectly.&nbsp; I used the raw date diff to store the date calc, and then just calculated the time change from that into another field.&nbsp; I created a rule that firsts resets the second field to the raw date diff, and then the second rule conditionally adjusts the value if necessary.</p> <p>Simple solution again.&nbsp; I was trying to hard to make it complicated.</p> <p>&nbsp;</p> <p>Thanks!</p>https://www.infopathdev.com:443/forums/thread/72987.aspxThu, 15 Dec 2011 17:00:03 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:72987Jimmy0https://www.infopathdev.com:443/forums/thread/72987.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=72987<p>How about having two fields for the date difference?&nbsp; One (RawDateDifference)&nbsp;holds the result of qRules DateDiff calculation, and the other (AdjustedDateDifference) holds the value that takes the time into account?&nbsp; Then when RawDateDifference or the time change, just recalculate AdjustedDateDifference.</p>https://www.infopathdev.com:443/forums/thread/72983.aspxThu, 15 Dec 2011 16:13:42 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:72983shniggens0https://www.infopathdev.com:443/forums/thread/72983.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=72983<p>I have 2 date fields that calculate the difference between days, and give the total in another field.&nbsp; (thanks, Qrules)</p> <p>I have another field for time.&nbsp; If the time is greater than 12:00 it subtracts half a day from the total.&nbsp; </p> <p>The problem I&#39;m having is, if I change the time to another time greater than 12:00 (noon), it will subtract again, which is not what I want.&nbsp; And if I change the time to be less than 12:00, the previous calculation will still be there, obviously.</p> <p>What would be the best way to approach setting the total depending on what the time field is?&nbsp; Should I use an eval function or something?&nbsp; </p>