| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Including date in SQL Where-clause in Excel 2007
On Tuesday, October 17, 2017 at 6:58:13 PM UTC+3, wrote:
What do the curly brackets mean? What does the ts mean? What happens if you leave those out? What is the format of the 2 date/time columns? RBS In fact I found a work-around: I changed all dates to numeric value built up of yyyyMMdd. Date format seem to confuse SQL. I thought it handles the dates as Excel serial numbers. HBJ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate including a date so that the date appears as a date | Excel Worksheet Functions | |||
| Can I use a between clause or in clause on an IF statement | Excel Programming | |||
| Including today's date | Excel Discussion (Misc queries) | |||
| Mimicking an GroupBy Clause in Excel | Excel Programming | |||
| VBA excel - problem with having clause in sql with adodb.connection/recordset | Excel Programming | |||
Threaded Mode
