What is the sysdate equivalent in Access docmd.runsql?

[01-7700]

I've tried sysdate in an sql statement, ie "select a,b,c from d where submitted_date > sysdate - 30;" and get an error - unknown function. I have googled for the answer and not found a reference to this. Does anyone know the answer? Thanks.

 

[Joe4]

Another minor detail DoCmd.RunSQL would require an action statement (Insert/Update/Delete) and I'm not sure it will do anything withSelect.

Very true. Running a SELECT query in VBA doesn't really accomplish anything.

Typically, you would either run an Action Query in SQL, or perhaps build some SELECT query SQL code so you can assign it to an existing query (that may be used by Reports/Forms, etc).

 

[mrmmickle1]

xenou & Joe4,

Thanks for the correction I have used hashes in the past... and I agree when running SQL from vba it can be tricky.....

I remember debugging code a few years ago where I had put an * in the VBA SQL string.... It wouldn't take it seeing as % is necessary when using VBA. I was on the verge of going bonkers.

Just because it worked does't mean it's the correct way to do things.

@xenou

Seems like we always get aboard these Access Date Threads

ahhahahhah

 

[xenou]

Keeping you on your toes