Convert date to lowercase month

[VegasNath]

I need to convert a date into a lowercase string for a vba variable.

Password2 = Password1 & (LOWER(Text(strDateWork, "mmmm")))

Where am I going wrong? TIA

[HansV]

LOWER and TEXT are worksheet functions, not VBA functions.
The VBA equivalent of LOWER is LCase.
The VBA equivalent of TEXT is Format.
So try

LCase(Format(strDateWork, "mmmm"))

By the way, shouldn't you use a date variable for the date instead of a string variable? The prefix "str" of the name strDateWork suggests that it is a string variable.

[VegasNath]

Thanks Hans.
Good point, I keep adopting bad habits.