How to solve date issue?

[#1]

Hi,

When I select DATE thru date listbox, it displays correctly. (see image below)

But when I select date thru Year, Month, Day, listboxes.. it displays nothing... (see image below)

Please help. I can't fix for now! I need experts working on dates.

[#2]

have you created them from same source?

Ex Date field:

Year(Date) as Year,

Month(Date) as Month)

Day(month) as Day

[#3]

Yes, I already have calendar for this.

[nilesh_gangurde]

Hi billiringer,

To get this work out First create the Master Calender table and link it to the base table with the "Date" Field.

Regards,

Nilesh Gangurde

[#5]

I already have that, check the structure below

but still I have problem which I mentioned above!

[renjithpl · Accepted solution]

=sum({<Date={"$(=max(Date))"}, Year=, Month=, Day=>} Sales)

you could try this..

[#7]

Thanks renjthpl... Got it!

[#8]

Got this, this is the answer

Thanks for the help!