Straight Table - Window Title Expression

[#1]

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

[arulsettu]

try this

month(Today())-1

[tresB]

Try like:

'Projects Completed in ' & month(Addmonths(vtoday,-1))

[Anonymous]

try this Expression:

'Projects Completed in ' & date($(vtoday),'MMMM')

[jonathandienst]

Like this:

= 'Projects Completed in ' & Month(vtoday-1)

(assuming vtoday is a valid QV numeric date)

[#6]

did not work

[#7]

did not work

[#8]

as today September is coming, i need value as August, so your suggestions will not work

[#9]

as today September is coming, i need value as August, so your suggestions will not work

[jonathandienst · Accepted solution]

= '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))