|
Subject:
|
Convert SQL to Microsoft Query
|
|
Posted By:
|
tgates
|
Post Date:
|
4/18/2008 1:49:41 PM
|
I have this current code written in SQL.
where jobname = 'ICE_GAS_DA'
and delivdate = dateadd(day, 0, convert(datetime, convert(varchar(10), getdate(), 101)))
MS Query does not recognize this and will not display the data. Anyone know of a similar MS query? I also would not mind if you have an MS query that will pull a date from a cell entered manually.
Anything would help. Thanks.
|
|
