i am writing a cursor and I want to give certain information because, for example the budget year 2000 is from november 1 2000 to october 31 2001. If i am considering the budget year 2000, I want to say if order_1 is done between november 1 and december 31, the budget year is 2000 and if it dated between january 1 and october 31 i have to have 2001, if i am considering the budget year for 1999, and the order_1 is between novemebr and december, it will be 1998 for, january to octber it will be the budget year 1999.
Could you help, please by the way the budget year datatype in number (4)
thank you
Could you help, please by the way the budget year datatype in number (4)
thank you