YTD,MTD function 2

[ub1234567]

Hi everyone,

i would like to know, that like
year to date and month to date function (YTD,MTD)

year to month function is qvailabel in crystal XI or not ?

thanks.

 

[lbass]

According to your stats, you have started 30 threads this month alone, and have responded to only two of them. This means that the person who attempted to help you has no idea whether his/her time was well-spent, and other readers do not know whether the suggestions solved the problem. I for one am reluctant to continuing responding to your posts unless you actively participate--and that also means attempting to help others with their issues.

-LB

 

[ub1234567]

hi lbass,

you are right but i am beginner in crystal report
so i am afraid that my solution or suggstion may not be appropriate to user.

but i am extramely apologize for that..

Thanks Lbass..pls Helpt me .....
i am stuck in my a lot of reports...

 

[lbass]

You can tell what functions are available by looking in the functions list in the formula editor. You should also take time to use the Help function in CR which is very good, and which explains how to use these functions.

If you are asking whether there is a function like to "year to current month end" or "year to end of lastfullmonth", the answer is no, but you could use formulas like this:

//{@year to end of current month}:
{table.date} in minimum(YearToDate) to dateserial(year(currentdate),month(currentdate)+1,1)-1

//{@year to end of last full month}:
{table.date} in minimum(YearToDate) to maximum(lastfullmonth)

-LB

 

[ub1234567]

thanks lbass. i will try my best

 

[ub1234567]

HI LBASS,

i am very beginners in crystal XI.
that is why i am posting many question and my problem.

i am also trying to solve myself and searchng on google.

but do not take my post wrong way and pls i am expecting that you are the one who reply my all post atleast.

thanks LBASS my friend.

 

[henbz]

//{@year to end of last full month}:
//{table.date} in minimum(YearToDate) to maximum(lastfullmonth)


Wow! This one is so simple and clean. Two tumbs up!

 

[cubeblock]

Hi Lbass, Another beginner here I am afraid. What does the symbol // denote in your formula lines?

Thanks

 

[dgillz]

// makes it a comment, you should not use it in your formula.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html