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

[Anonymous]

try

'Projects Completed in ' & date(addmpnths(vtoday,-1),'MMMM')

your variable is correct vtoday or vToday?

in your first  mail you mentioned vToday has todays date

[chetansehgal]

Try this:

='Text'  &  left(MonthName(addmonths(Today(),-1)),3)

[tresesco]

Try:

month(Addmonths(today(),-1))

[Anonymous]

Hi,

use this expression.

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

regards,

Venkata Sreekanth