Set Analysis monthstart(today()) does not work in January

[#1]

I am currently using these formulas to pull the current month and previous mtd.  For January I am getting some crazy numbers. 

Current Mtd:

sum({<Tran Date]={">=$(=monthstart(today()))"}>}Fees)

Previous month to date:

sum({<Tran Date]={">=$(=monthstart(max(trandate),-1) & '<=' & Addmonths(max(trandate),-1))"}>}Fees)

If someone could help me adjust these formulas to pull correctly, I would greatly appreciate assistance.

Thanks,

Kristy

[jduenyas]

Check your systems calendar/date.

Your are still living in last year. 🙂

[swuehl]

  Why in the world would it be 12/1/11?!

Another possibility:

today() is equivalent to today(2), which means: Date when the document was opened

I assumed that you have opened the document after Jan 1st, but maybe you have still kept it open since last December?

[jduenyas]

Brilliant!

Now I understand why I do not get good data when I keep my application open over night or over a weekend.

Thanks a lot.

[#5]

HAHA! That is why it says today=12/15. It stays open on the server.

Thank you so much,

Kristy