Hello,
I had many calculations in my calendar that added the number of appointments per month and the price per all of the appointments.
I had the calculations actaully telling me how many i did the previous month per the current month so that i could keep goal.

Now that it is 2010, my dates are messed up.

I was using a date range of the first of the month through the current date for my current month and the first of the month for last month through the current date to see where i was compared to this time last month and so on.

Any easy fixes to add some sort of year function?

Howdy,

Sounds like your relationships were just based on months. Try adding a year component to the calcs you use to related previous months together.

Can you please help me find the calculation to get the date from previous months.

Currently say I have 4 fields:
-First Day of Mo
-Last Day of Mo
-First Day of previous mo
-Last Day of previous mo

I use these to move from month to month and compare sales/jobs on a this date current month versus this date on a previous month....

First Day of mo = Date ( Month ( CalFilterDateGlob ) ; 1 ; Year ( CalFilterDateGlob ))

Last Date of mo = Date ( Month ( CalFilterDateGlob ) + 1 ; 0 ; Year ( CalFilterDateGlob ) )

First Day of last mo = Date ( Month ( CalFilterDateGlob ) -1 ; 1 ; Year ( CalFilterDateGlob ))

Last Day of previous mo = Date ( Month ( CalFilterDateGlob ) ; 0 ; Year ( CalFilterDateGlob ) )

How would i incorporate a year function so that i can switch between Jan 2010 and Decemeber 2009...and then when Feb comes, i want it to be normal between Feb and Jan....and so on....

Thanks for the help!

Hey Robin,

It looks like you already have a year component since your calcs are all returning dates. (Some people would just use the month numbers to compare, hence the potential problem).

I'm not sure what your problem might be as these calcs look right on to me. Maybe the problem is in the relationship?

Hmmm...this is tricky.

Here is an example of one of my relationships.
For calculations that show current month stats compared to the previous months stats:
Using the fields that I mentioned earlier, the relationship is

Frist Day of last MO is less than or equal to the job/sale date
AND
The "Curent Date" of last month (i.e. today is the 5th, so this would be the 5th of the previous month, Dec 5th) is greater than or equal to the job/sale date

This gives me all of my job stats on the current date based upon where i was a month earlier on the same date.

Based upon the fields that I explained earlier and this relationship description, is there anywhere you can see where i am going wrong?

What's your The "Curent Date" of last month calc?

Date (Month (CalFilterDateGlob) -1; Day (CalFilterDateGlob); Year (CalFilterDateGlob))

Hmmm.I don't see it. Give me a ring and we can schedule a screen share to check it out: 206.715.2126

Hey!
I got it figured out. Everything is good to go.
Thanks so much for your help!