Joined: 30 Oct 2008
Location: United States
Online Status: Offline
Posts: 44
Topic: If Then Posted: 11 May 2012 at 8:49am
Hello...
Any idea why the following formula doesn't work for me?
If {@Days Between Resolve and Invoice Dt} <=60 then "Yes" else "No"
Formula pulls in a Yes for all records regardless.
The {@Days Between Resolve and Invoice Dt} <=60 formual is a datediff formula between two date fields. Everything works other than no pulling if the order is greater than 60 days old.
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 11 May 2012 at 9:02am
place @days formula on the report canvas to see if you get the expected days. If you reversed the dates in the formula all of hte values will likely be negative which would always give you a 'YES' in your other formula
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
