Not 100% sure what you are up to, but you can try Today()... If you want a
text string to embed in a SQL statement then you can use

format(Now(), "yyyyddmm") in VBA or
Text(now(), "yyyyddmm") in Excel
--
HTH...

Jim Thomlinson


"Ronald S. Cook" wrote:

I'm trying to write SQL within Excel. I'm used to Date() and Now() but
those don't seem to work. Can anyone tell me the equivalent?

Thanks,
Ron