I am converting our Access Database to a new fiscal year and have an encumbrance report that is supposed to start picking up services starting 7/1/2014 and it is calculating from the beginning of the placement, ie before 7/1/14 not after. The other report with the same formula is working fine. I can't figure out where else to look? The formula I have in both Queries is - DAYS: IIf(([BEGIN]>=#7/1/2014# And [END]<=#7/1/2015#),([END]-[BEGIN]),(IIf(([BEGIN]<#7/1/2014# And [END]<=#7/1/2015#),([END]-#7/1/2014#),(IIf(([END]>#7/1/2015# And [BEGIN]>=#7/1/2014#),(#7/1/2015#-[BEGIN]),(IIf(([END]>#7/1/2015# And [BEGIN]<#7/1/2014#),(#7/1/2015#-#7/1/2014#),"Error, check dates"))))))) one is working, one is not.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.
Your password has been sent to:email@example.com
To follow this tag...
Thanks! We'll email you when relevant content is added and updated.
Share this item with your network: