vba help - format date

[Mallesh23]

Hi Team,

I am creating a string for Report Title , My code is working , but can we shorten code here.

I have used Format(date) twice to get ====> Dec'20"
Format(Date, "mmm") & "'" & Format(Date, "yy")

Sub ReportName()

Dim str As String

str = "Recon Report from Apr'19 - " & Format(Date, "mmm") & "'" & Format(Date, "yy")

Expected Code :=> "Recon Report from Apr'19 - Dec'20"


End Sub

Thanks
mg

 

[JoeMo]

Maybe:

str = "Recon Report from Apr'19 - " & Format(Date, "mmm 'yy")

 

[Mallesh23]

Hi JoeMo,

Perfect ! Thanks for your help, it worked as expected. ?


Thanks
mg