Format() and DateAdd() together - VBA

[Ughes]

Hi Guys,

Hope everyone is well.

Just a quick one today.....i hope!

I am trying to select and format today's date minus 1 day.

Code so far:

strSaveName = "Bookings Details " & Format(DateAdd("dd", -1, "mmddyy"))

Any body have any ideas why I am getting the type mismatch debug for this one?

Much appreciated - hopefully it only requires a small change.

Regards
Ughes

 

[Jonmo1]

Try

strSaveName = "Bookings Details " & Format(Date - 1 ,"mmddyy")

 

[Ughes]

You beauty! (sorry, bit of an Englishism)

Thank you for the help, jonmo1 - greatly appreciated.

Regards
Ughes