Hi, I need help with a script in 10g. The requirement is to create a string from three different variables in the following format: 'YY-1234-XX' - (BTW, '1234' is irrelevant for this discussion).
YY is the last two digits of the company's fiscal year, which runs from October 1 - September 30th. They are using this to track the number of projects created within this time frame, with the counter being represented here by 'XX.' I need to account for the fact that if a project is created between 10/1-12/31 of the current year, the next years two digit value is entered in as 'YY' and the counter clicks up one. An example: Project is created 11/1/2008. String would read: 09-1234-01 Project is created 2/1/2009 String would read: 09-1234-02 I don't need help with the counter, I just need to know how to 'shift' the system date to meet the requirement. Any help is appreciated. Many thanks. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
