change the numberformat to yyyymmdd

[OneMixedUpStranger]

Hello

I need to change a format of a variable that looks like this

SynaDag = Calendar1.Year & Calendar1.Month & Calendar1.Day & ".txt"

this returns the format yyyymmd when the day is under 10
(2001127)

what i need is the numberFormat yyyymmdd (20011207)
I know that if I would be working with a cell in Excel it would be

Selection.NumberFormat = "yyyymmdd"

Please post any suggestions

Thanks

 

[JustinEzequiel]

dim dYourDate as date

SynaDag = format$(date,"YYYYMMDD&quot & ".txt"

 

[OneMixedUpStranger]

thanks