I'm trying to write a query to update a different date in sql without success.
getting all kind of errors with the conversion types.
I live in Israel, so the my date format is like DD/MM/YYYY, althought in SQL it shows like this 1988-02-01 19:03:00.
I need something like this.
UPDATE PORDERITEMS SET DUEDATE = 15/06/21
the column for DUEDATE is defined as bigint (if it helps)
once I'll get it done, the goal is connecting excel to SQL, pulling some records, changing the dates for some of those records
and write VBA code that will update the SQL with the new dates. (the connection to excel and the VBA already done, just missing the syntax for changing the dates)
thanks in advance