Skip to main content
Question

Report Formula - If statement for duration (Deposit Date > Posted Date)

  • February 10, 2020
  • 0 replies
  • 26 views
Trying to calculate the duration (TAT) from a deposit date to when it was posted. Have the formula correct but since I have some posted dates (CB Posted Date) that is before deposit date (As Of), it is showing a large value like it would in excel. The dates are correct. Either need to ignore those dates/postings or make it blank. 

If([CB Posted Date]=null,null,
[CB Posted Date]<[As Of],null,
[CB Posted Date]>[As Of],[CB Posted Date]-[As Of])

thoughts??


------------------------------
Mark Davis
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+15
  • DonLarson
  • Registered
  • February 10, 2020
Mark,
I am assuming you have a Formula Duration field.  Give this a try:

if (  isnull([CB Post]),  null,
[CB Posted Date]<[As Of], null,
[CB Posted Date]>[As Of],[CB Posted Date]-[As Of])

------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
Terms & ConditionsAccessibility statement