reading/inserting variable dates within a macro
By the way, I had to remove the quotation marks around the
A1 and the yyyy-mm-dd in order to avoid that Compile error.
-----Original Message-----
Thanks, Bob, for your attempts. Please read below. I
understand if you don't want to continue to deal with
this. Maybe someone else out there has a solution. Dan
-------------------
Hmmmm. Maybe I was coming at this from the wrong
direction. I tried your latest solution (?Format etc.).
The macro then allowed me to enter two parameters (dates,
I presume). I entered the "from" and "to" dates. It
still bombs out ... at the last line (below):
..Refresh BackgroundQuery:=False
It bombs out with "true" too. When I comment it out, it
doesn't bomb out but no data gets returned.
.Name = "Query from V1DATA"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = True
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.PreserveColumnInfo = True
.Refresh BackgroundQuery:=False
If anyone wants to try, please let me know. Thanks. Dan
-----Original Message-----
Sorry I was of no help. If you type ?Format(Range
("A1"),"yyyy-mm-dd") in the
immediate window, it works okay. The curly braces threw
me, have you tried
removing them?
Other than that, I hope someone else can help.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Dan Wasser" wrote
in message
...
Thanks. Nice try. But it didn't work. I get this
error:
Compile Error: Expected: list separator or )
It seems like it doesn't like the quotation marks
around
the A1 (or A2). I'll keep playing with it but if you
or
someone else has other suggestions, I'd appreciate
it.
Dan
-----Original Message-----
Dan,
Not tested, but here's a stab
WHERE (STAY.S_ADATE={Format(Range("A1"),"yyyy-mm-
dd")}
And
STAY.S_ADATE<={Format(Range("A2"),"yyyy-mm-dd")})
--
HTH
Bob Phillips
... looking out across Poole Harbour to the
Purbecks
(remove nothere from the email address if mailing
direct)
"Dan Wasser"
wrote
in message
...
I'm trying to write a macro but can't figure out how
to
insert a variable "from" and "to" date within the
instructions.
Here's the portion of the macro that I can't figure
out:
WHERE (STAY.S_ADATE={ts '2002-12-31 00:00:00'} And
STAY.S_ADATE<={ts '2003-04-30 00:00:00'})
.
.
.
|