You need to sign in to do that
Don't have an account?
lady_syrenne
Need help with dates! URGENT!
Hi All!
I'm having hard time to fetch the startdate of fiscal year without querying it.. How can I do this? Does Anyone know?Pls. help this is very urgent!
Regards,
Lady
Please check with this
THIS_FISCAL_QUARTER
Starts 12:00:00 on the first day of the current fiscal quarter and continues through the end of the last day of the fiscal quarter. The fiscal year is defined in the company profile at Your Name | Setup | Company Profile | Fiscal Year.
SELECT Id FROM Account WHERE CreatedDate = THIS_FISCAL_QUARTER
Can I use this to know the first 90 days of the fiscal year?
Yes but you need to midify in the following manner
NEXT_N_FISCAL_?YEARS:n
Starts 12:00:00 on the first day of the next fiscal year and continues through the end of the last day of the nth fiscal year. The fiscal year is defined in the company profile at Your Name | Setup | Company Profile | Fiscal Year.
e.g.
SELECT Id FROM Opportunity WHERE CloseDate < NEXT_N_FISCAL_YEARS:3LAST_N_FISCAL_?YEARS:n
OR
LAST_N_FISCAL_YEARS
Start 12:00:00 on the first day of the last fiscal year and continues through the end of the last day of the previous nth fiscal year. The fiscal year is defined in the company profile at Your Name | Setup | Company Profile | Fiscal Year.
e.g
SELECT Id FROM Opportunity WHERE CloseDate > LAST_N_FISCAL_YEARS:3
This may help you
Thanks
for more information check this one
http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_calls_soql_select_dateformats.htm