Logic help

[abhaysingh]

right now month DEC 14 is running, here i am following Financial Year April to March,

when i go to Day Level and try to find max(date) of current month it is giving me 31st dec 14 but it should be 03-dec-14.

can any one help me in this.

if  need master calender script i can provide that

[jonathandienst]

Hi

It seems you have loaded dates up to 31 Dec, so max(date) will return 31 Dec. Do you want the max(date) to be limited to today, or to dates containing transactions

     =RangeMin(Today(), max(date))

     =max({<date = {"=Count(Sales) > 0"}>} date)  (fix field name to match your model)

HTH

Jonathan

[jagadeesh_diamo]

Can you please clarify which output you want? dynamic or standard?

If you want todays date, why dont you use today() function?