1. Description

     In each database there is a function, which returns the current date (and time). If those functions are used, you do not need the conversion into the current date format of the database.

  2. Answer

    Access ConActual.Execute "Update data set printedat = now where form_id = 25 and Status = 1 and Job_id = " & sJobID SQL-Server ConActual.Execute "Update data set printedat = getdate where form_id = 25 and Status = 1 and Job_id = " & sJobID Oracle ConActual.Execute "Update data set printedat = sysdate where form_id = 25 and Status = 1 and Job_id = " & sJobID

Date created:
01/22/2015 11:38:32
Last updated:
02/11/2015 10:25:20
Product(range):
OMS-500
Print