insert system date. no date and time
I try to update a table with system date. it does not work. no system date and time.
my query as
***UPDATE ADJFLAT SET ADJFLAT.ImportDate = Format(Date(),'mm/dd/yyyy')
however, i am still got system format of date and time
as 11/18/2003 0:00:00.
But i am only need to 11/18/2003 as output results