Hi everyone,
I am trying to add daily discharge data to my inlet point in SWAT editor.
I formatted the data according to the "pointsdaily.txt" example file (from C:\SWAT\SWATEditor\Databases\ExInputs), see the attached file.
However, I keep getting the error "Column 'DATE' does not belong to table tbITs."
I have tried many different date formats (m/d/yyyy, d/m/yyyy, m-d-yyyy, mm/dd/yyyy, yyyymmddd, etc.) as suggested by other users, but nothing works (except that the error changes to "Syntax error in FROM clause" when I use a date format with '-').
Am I using the correct format? Does anyone have a suggestion on how to fix this?
Also, is it correct to put in "-99" for missing data in this file?
Thank you!
Kind regards,
Eva