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

See the red text.

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