T
Terry Higgins
New at this - I want to use a select query to output and excel file. The
query needs to use a start date and end date within a joined table on an
AS400. The dates on the AS400 are YYYYMMDD. I figured out how to calculate
my start date and end date based off the current date, but how do I get this
automatically into a query where the criteria is Between [StartDate] and
[EndDate].
This is how I am getting the StartDate
Format (Date-7,"YYYYMMDD")
This is how I am getting the EndDate
Format (Date-1,"YYYYMMDD")
query needs to use a start date and end date within a joined table on an
AS400. The dates on the AS400 are YYYYMMDD. I figured out how to calculate
my start date and end date based off the current date, but how do I get this
automatically into a query where the criteria is Between [StartDate] and
[EndDate].
This is how I am getting the StartDate
Format (Date-7,"YYYYMMDD")
This is how I am getting the EndDate
Format (Date-1,"YYYYMMDD")