Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
i want to show current year and current month by opening a document with out using MAX function
You can Take a text box and write below expression in it to display current year and month:
For Current year:
=Year(Today())
For Current Month:
=Month(Today())
I hope this is what you want..!
You can get the current year and month by using Year(Now()) and Month(Now())
Hi Kannuri,
In a Text box use this:
='[ Updated at ' & timestamp(reloadtime(), 'hh:mm on MMM DD, YYYY') &' ]'
Thanks,
AS
Year(Today())
Month(Today())
You can Write below in any text box or in variables
For Year >> =Year( Now( ) )
For Month >> =Month( Now( ) )
And also you use
=Year(Today( ) )
=Month(Today( ) )