Date modified not updated when running queries with scheduler

[projecttoday]

When I run an insert query from the database the table's date modified is changed but when I run the query with Windows Scheduler the table's date modified is not changed. Is this possible? Any suggestions on how to get around it?

 

[boblarson]

I can't tell you the reason that is happening for you but I can suggest not relying on that property. Put a field in the table for last update and then include Now() in the insert query to place the date/time it was updated there.