Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
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.
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.
I think that would happen, since each there is only one day associated with each date?
Hi,
I created a version of your qvw with a new field and a new action to accomplished what you wanted.
Best Regards,
Erich
Already said in my question....
I don't want to use Date Field here...
Hi,
Please find the attachment.
Thanks,
Jagan
Thanks Jagan,.... But you also have used (indirectly) my Date Field....
I want this to be achieved using
Day and Month field only....
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.
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)