Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
I want to creat a variable which should show current month today
how can i do this ?
=num(month(now()))
it will display month to num for example June the above definition will display '6'
Is that Current month in selection? Perhaps this
LET Variable1 = Today();
Hi,
You can create variable like below,
vMaxMonth
=max(Month(Today())) // this will return latest year month no
or
=MonthName(addmonths(today(),1)) // this will return latest year with month name
and also you can write the expression in chart like below
=$(=max(month(Today())))
Hope this helps you
Regards,
Deva
Hi Anil
NO we are not making any month selctions ,
i have month as a field in the script which has moths in that ,
So i want to have to vairable whch should shouw current month
thanks
You can create variable in variable expression or using LET
vCurrMonth=month(Today());
=Month(Today()) will display Jun
just do Ctrl+Alt+V then click on add
name write vMonth in definition =Month(Today())
Hi there,
You can also do this by
LET vMonthYear =monthname(Today())
it will give you 'Jun 2017'
Thank You.
Thanks for the reply mahesh ,
How can we cover the month field which has text as jun,jul,august ....son into month number ?
I want to display the current month into number
Thats is 6 for jun ?
=num(month(now()))
it will display month to num for example June the above definition will display '6'
=num(month(Today()))