FORMAT not working for Date to text as expected

I used to know how to do this, but have been away for too long. I have an Excel 2010 macro I am working on that spits out a fixed field file as it's final output. The file is generated daily and is FTP'ed daily to the client's server. The client wants the format to be INSPECTION2013030154726.TXT. I was using the format function with a format, but the date and time are unchanged from system settings:

    todayDate = Format(Now(), yyyymmdd)
    todayTime = Format(Now(), hhmmss)

I am still playing with it, but not remembering how to do it. Any clues?

That was part of it. Much thanks!

Originally Posted by oeldere

Not sure about it, but you can give it a try.

See the red text.

todayDate = Format(Now(), "yyyymmdd")

SOLVED!

    Dim todayDate As Date
    Dim todayTime As Date
    Dim yestDate As Date

...should hyave been...

    Dim todayDate As String
    Dim todayTime As String
    Dim yestDate As String