VBA Date Issue

[playern07]

Hello all,

I am trying to get a particular date in the format of yyyy-mm-dd, but no matter what I do VBA returns mm/dd/yyyy. Any ideas why this would occur?

Dim DateVariable As Date
Worksheets("Sheet1").Activate
DateVariable = Cells(2, "B").Value
DateVariable = Format(DateVariable, yyyy - mm - dd)

 

[Joe4]

The FORMAT function creates a Text/String value, but your date is formatted as Date. Also you need quotes around your format option.

Try:

Dim DateVariable As String
Worksheets("Sheet1").Activate
DateVariable = Format(Cells(2, "B").Value, "yyyy - mm - dd")

 

[playern07]

Thank you! This minor alteration makes it work perfectly!