Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I want my report to always open with the current year and month.
How can I do this?
/Stefan
May be use On Open Triggers
1)
Field
Year
Search String
=Year(Today())
2)
Field
Month
Search String
=Num(Month(Today()), '00')
Many ways for this
1. By SET Analysis
2. BY Trigger.
You can try some this ways by trigger.
1. For Year Field = Year(Today())
2. For Month Field = Month(Today())
Works fine.
Thank You