Set date format for variable

[GonzoB]

Hi Helpers,

I need to set the date format for my variable to this: yyyy-mm-dd. Can you tell how can I do this? What I have by default is this: mm/dd/yyyy

​

This is how I declare my variable:

    Dim Today As Date
    Today = Date

I have a long VBA where I use this to populate many fields. In some fields Today stands alone, in others it's concatenated with other strings.

Thanks in advance

 

[davesexcel]

range("A1")="Today is " & format(Today,"mm/dd/yyyy")

Normally one would not use "Today" as a variable as it is part of an excel function.