Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a scenario,In that I have to calcualte YTD values on calender year.For example If am in currently Aug 2010,so I have to show YTD Values for Jan2008-Jul 2008 ,Jan 2009-Jul 2009 and Jan2010-Jul 2010.if anybody had same kind of scenario then share with me.
Thanks& Regards
Jai
Good day,
I don't really see what is your problem.
Could you please look at this application, an tell me if this is what you aim ?
Hi,
Thanks for your kind reply.Thing is the month field is in Char form like 'Jan','Feb','Mar' like that.That is why I am having small issue.If
you have any solution then please share with me.
Thanks & Regards
Jai
"Jan", "Feb", ... is only a display format.
Surround your month field with "num( ... )", and this will give you "1", "2", ...