Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i am using this expression in Window Title: = 'Projects Completed in ' & month(month(vtoday)-1) and the value i am getting is below:
Projects Completed in 8
vToday variable is giving todays date
expectation of the result is:
Projects Completed in August
please advise
thanks in advance
Sukhwant
= 'Projects Completed in ' & Month(AddMonths(Today(), -1))
If vtoday is a valid QV numeric date (and remember that variable names are case sensitive - vtoday and vToday are two distinct variables):
= 'Projects Completed in ' & Month(AddMonths(vtoday, -1))
= 'Projects Completed in ' & Month(AddMonths(vToday, -1))
try this
month(Today())-1
Try like:
'Projects Completed in ' & month(Addmonths(vtoday,-1))
try this Expression:
'Projects Completed in ' & date($(vtoday),'MMMM')
Like this:
= 'Projects Completed in ' & Month(vtoday-1)
(assuming vtoday is a valid QV numeric date)
did not work
did not work
as today September is coming, i need value as August, so your suggestions will not work
as today September is coming, i need value as August, so your suggestions will not work
= 'Projects Completed in ' & Month(AddMonths(Today(), -1))
If vtoday is a valid QV numeric date (and remember that variable names are case sensitive - vtoday and vToday are two distinct variables):
= 'Projects Completed in ' & Month(AddMonths(vtoday, -1))
= 'Projects Completed in ' & Month(AddMonths(vToday, -1))