What is Date() equivalent in Excel?
 

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

What is Date() equivalent in Excel?
 

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