Fiscal Years and Quarters
| From: | Don Wieland | Date: | Tue, 19 Oct 2010 23:11:53 +0000 |
| Subject: | Fiscal Years and Quarters | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-308860@lists.php.net to get a copy of this message | ||
Hello,
I have a preference field called "Fiscal_Year_Start_Month" which has the Month Names as options.
Based on this value, I need to calculate the following date in UNIX:
Current_1st_Quarter_Start_Date
Current_1st_Quarter_End_Date
Current_2nd_Quarter_Start_Date
Current_2nd_Quarter_End_Date
Current_3rd_Quarter_Start_Date
Current_3rd_Quarter_End_Date
Current_4th_Quarter_Start_Date
Current_4th_Quarter_End_Date
Last_1st_Quarter_Start_Date
Last_1st_Quarter_End_Date
Last_2nd_Quarter_Start_Date
Last_2nd_Quarter_End_Date
Last_3rd_Quarter_Start_Date
Last_3rd_Quarter_End_Date
Last_4th_Quarter_Start_Date
Last_4th_Quarter_End_Date
Next_1st_Quarter_Start_Date
Next_1st_Quarter_End_Date
Next_2nd_Quarter_Start_Date
Next_2nd_Quarter_End_Date
Next_3rd_Quarter_Start_Date
Next_3rd_Quarter_End_Date
Next_4th_Quarter_Start_Date
Next_4th_Quarter_End_Date
Then based on TODAY'S date
Current_Fiscal_Quarter - result will be 1, 2, 3,or 4
Don