Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Possible to get "Date Modified" when connecting to Access DB

I'm using ODBC CONNECT32 to retrieve data from an access database.  I'd also like to retrieve the "date modified" associated with this access db so I can include that date in my report.  Is this possible?  If so, how?

Thanks!    Dan

3 Replies
Not applicable

Re: Possible to get "Date Modified" when connecting to Access DB

May be you can use Max date from your table.

Not applicable

Re: Possible to get "Date Modified" when connecting to Access DB

Unfortunately the table has no date field.  All the data in the table is "as of" the date it is refreshed. 

Not applicable

Re: Possible to get "Date Modified" when connecting to Access DB

Then use As of Date or may be check with Access DB DBA to get this from System tables like other DB's

Community Browser