| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add Number to variable date
Hi Experts,
I have a variable for date that calls in SQL for cut of time : Vardate1= Format(Me.TextBox1.Value, "DD MMM YYYY") : : " AND (Table1.DATE_SCH='" & Vardate1 & "'" & _ What I need is how add 180 days to this cut of time automatically, I tried : AND (Table1.DATE_SCH='" & Vardate1 & "' + 180" & _ But I didn't get proper date, Thanks in advance for any help Bijan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error Number: 91 object variable or With block Variable not set | Excel Programming | |||
| add 2 months and a variable number of days to a date | Excel Worksheet Functions | |||
| calc constant date from variable date & return with ability to rn. | Excel Worksheet Functions | |||
| Compare Date in Cell VS a Variable Date to Hide Row | Excel Programming | |||
| Using a variable as a Row number | Excel Programming | |||
Threaded Mode
