YTD comparision on calender year

[#1]

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

[#2]

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 ?

[#3]

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

[#4]

"Jan", "Feb", ... is only a display format.

Surround your month field with "num( ... )", and this will give you "1", "2", ...