Solved Log time and date a query was last run? (1 Viewer)

[Number11]

Public Function fncLog() As Boolean
    CurrentDb.Execute "insert into tblLog(QueryName, [Last Run]) " & _
        "select '" & CurrentObjectName & "'," & Format(Now(), "\#mm\/dd\/yyyy hh\:nn\:ss\#")
    fncLog = True
End Function

That worked thanks

 

[arnelgp]

you're welcome.