ComputerNurse
MIS
I am writing a report to export billing data for Passport services. I need to set a contract year based on the date of service. I am trying to write please excuse the psuedo code:
IF service provided is between 7/1/02 - 6/30/03 then contract year = -7. I am going to need to do several years
can this be done using a case statement? What is the best way to code the date range?.....Please help.
IF service provided is between 7/1/02 - 6/30/03 then contract year = -7. I am going to need to do several years
can this be done using a case statement? What is the best way to code the date range?.....Please help.