What is Date() equivalent in Excel?

R

Ronald S. Cook

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 95 equivalent of modern events? 6
How refer to current date in Excel SQL query? 3
Ribbon's equivalent to CommandBars.ActionControl 5
std_ 1
Convert number to date 2
Is there an equivalent function? 4
Picture AlternativeText property Equivalent in Excel 97 1
What is the #define equivalent? 2

Top