What is Date() equivalent in Excel?

  • Thread starter Thread starter Ronald S. Cook
  • Start date Start date
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
 
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
Convert number to date 2
std_ 1
Picture AlternativeText property Equivalent in Excel 97 1
SqlParameter to SQL declare representation 4
What is the #define equivalent? 2

Back
Top