Dynamic Year

[RanjanThammaiah]

Hi All,

May I know what is the reason I am getting the wrong year in the title?

Tittle = "Sales Dashboard for"&" "&FORMAT(TODAY(),"MMMM") &" "& FORMAT(YEAR(TODAY()),"yyyy")

[ryan_mayu]

@RanjanThammaiah 

if you want to use format, you can also try this.

Tittle = "Sales Dashboard for"&" "&FORMAT(TODAY(),"MMMM") &" "& FORMAT(TODAY(),"yyyy")

[aj1973 · Accepted solution]

Hi @RanjanThammaiah 

Tittle = "Sales Dashboard for"&" "&FORMAT(TODAY(),"MMMM") &" "& YEAR(TODAY())

OR

Tittle = "Sales Dashboard for"&" "&FORMAT(TODAY(),"MMMM") &" "& FORMAT(TODAY(), "YYYY")

same result