• 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.

  • 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