Virus scan in progress. Please wait to download attachments.
Overview This example VI show how to retrieve information from a table in database which has columns defined as Date/Time data type.
Description This example has been tested with Microsoft Access 2013 and the most important is that you can retrieve information from a table in database which has columns defined as Date/Time data type. The most important in this example is to show you how to build your query since TimeStamp in LabVIEW must be reformatted in order to get a Microsoft Access valid format. This example has been built with an Event Producer Consumer structure. You can execute two specific queries: SELECT * FROM table_name SELECT * FROM table_name WHERE column_with_dates BETWEEN time_stamp_1 AND time_stamp_2