| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| NZ function equivalent in Excel | Excel Worksheet Functions | |||
| @DSUM (123) equivalent in excel | New Users to Excel | |||
| equivalent code in c# for excel | Excel Programming | |||
| Autotext equivalent in Excel? | Excel Programming | |||
| Excel equivalent of 'Keep lines together' | Excel Programming | |||
Linear Mode
