Hi,
I have a two fields in my table: 1) Dt_closed 2) Fileprep_end_dt
I'm trying to create a calculating field called "Days_in_NG" by using this logic in query design. If "Dt_closed" is null take Today's Date minus "Fileprep_end_dt." However, if "Dt_closed" is NOT null take Today's Date minus "Dt_closed". Please help! Thank you so much!
LH
Bookmarks