Max Day of Max Month

[MK_QSL]

For the enclosed file, when I open the Main Tab, I need the Maximum Day of Maximum Month to be selected by trigger.

I don't want to use Date Field here...

i.e. Max(Date) ...

I need something like

Max Day where Month = Max Month....

Hope I have explained clearly...

[#2]

Why does Max(Date) not work for you? It seems to get the job done.. Max Date will select Max Month and Max Day as well.

[MK_QSL]

It's working... but I want another way...Just for my curiosity...

Let's consider that the calendar is from 01/01/2014 to 28/12/2014...

I need the selection on Day should be 28 when I open the document.

[#4]

I think that would happen, since each there is only one day associated with each date?

[erichshiino]

Hi,

I created a version of your qvw with a new field and a new action to accomplished what you wanted.

Best Regards,

Erich

[MK_QSL]

Already said in my question....

I don't want to use Date Field here...

[jagannalla]

Hi,

Please find the attachment.

Thanks,

Jagan

[MK_QSL]

Thanks Jagan,.... But you also have used (indirectly) my Date Field....

I want this to be achieved using

Day and Month field only....

[Anonymous]

Hello, Manish.

Using the Date filed would be easier, but it seems it is not available in your app. Then, you could use these two expressions to select Month and Day respectively:

=Month(MakeDate(1, Max(Month), 1))

=Max({$<Month = {$(=Month(MakeDate(1, Max(Month), 1)))}>} Day)

Attached is a QVW with your calendar modified to go only until December 28 and selecting the appropriate fields when opened.

Cheers.

[jagannalla]

Manish - Use any number there like 0 or 1 or 0000 etc

=Month(MakeDate(1,Max(Month)))

=Max({<Month = {'$(=Month(MakeDate(1,Max(Month))))'}>}Day)