Hi All,
My Requirement Like this I want Calculate month start date to till date in previous month.
Scenario: Today's date is 11th Nov 2012.when you use To Date Function calculate the 1st Nov 2012 to 11th Nov 2012.But here we calculate the 1st sep to 11th sep in 2012.Find below query :
ToDate(Ago("Core"."Fact - CRM - Service Request"."% Open SRs" , "Core"."Date"."Month",1), "Core"."Date"."Month")
Thanks,
My Requirement Like this I want Calculate month start date to till date in previous month.
Scenario: Today's date is 11th Nov 2012.when you use To Date Function calculate the 1st Nov 2012 to 11th Nov 2012.But here we calculate the 1st sep to 11th sep in 2012.Find below query :
ToDate(Ago("Core"."Fact - CRM - Service Request"."% Open SRs" , "Core"."Date"."Month",1), "Core"."Date"."Month")
Thanks,
No comments:
Post a Comment