G
Guest
I'm trying to save current DATE + 1 month to table, but it doesn't save it as
a date format but shows something like this "7.83754898468115E-04" after
saving. I'm using following code
DoCmd.RunSQL "UPDATE Administrative" & _
" SET Field2 = " & DateAdd("m", 1, dd) & ";"
Where "dd" is defined as a DATE variable. What might be wrong? Could there
be any optional ways of completing this? Thanks!
a date format but shows something like this "7.83754898468115E-04" after
saving. I'm using following code
DoCmd.RunSQL "UPDATE Administrative" & _
" SET Field2 = " & DateAdd("m", 1, dd) & ";"
Where "dd" is defined as a DATE variable. What might be wrong? Could there
be any optional ways of completing this? Thanks!