var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: AS/400 Date Not Valid
I'm developing a program using VB6 and I need to update records in AS/400 database. I need to update current date into a timestamp data type field (PRCDATE) in AS/400 file.
strSQL = "UPDATE myAS400Library.myAS400File SET PRCDATE = '" & Now & "' WHERE " DISTCODE = '" & rs!DISTCODE & "' "
I'll receive error message "..Syntax of date, time or timestamp value not valid.."
I also tried to hardcode the value of PRCDATE as '2004-12-17 11:10:03.740424' but the same error occurs.
Need help with this..
Try sending the date format of YYYYMMDD or MMDDYYYY
Try to enclose your date with "#":
strSQL = "UPDATE myAS400Library.myAS400File SET PRCDATE = #" & Now & "# WHERE " DISTCODE = '" & rs!DISTCODE & "' "