current year and month

[#1]

Hi Community,

   i want to show current year and current month by opening a document with out using MAX function

[#2]

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..!

[ThornOfCrowns]

You can get the current year and month by using Year(Now()) and Month(Now())

[amit_saini]

Hi Kannuri,

In a Text box use this:

='[ Updated at ' & timestamp(reloadtime(), 'hh:mm on MMM DD, YYYY') &' ]'

Thanks,

AS

[MK_QSL]

Year(Today())

Month(Today())

[its_anandrjs]

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( ) )