Error in writing SWAT database tables " conversion from string “12/31/3000” to type ‘Date’ is not valid"

[Razna Rahim]

Dear all,

   

                    I am using ArcSWAT 10.1, when I attempt to write SWAT input tables,  I keep getting an error ‘conversion from string “12/31/3000” to type ‘Date’ is not valid’.

     In my input files, I didn't use the year 3000 anywhere, but the error occurs.

 

 How can I overcome this problem?

 

 

Razna

 

[Adu]

hi Razna!

You have to change the date format in your computer to US format (mm/dd/yyyy)

Regards,

Adriano

[Elias Nkiaka]

Dear sir,

Good afternoon. After changing the date format to the American date format as suggested did your model function? I have the same kind of problems too.

Cheers

[Jiajia Liu]

Hello, I have ran into the same problem.

[Jiajia Liu]

I have done so, changed my date to US format, doesn't work

[Jiajia Liu]

Hi, i just tried that out. It didn't work!

On Tuesday, February 10, 2015 at 4:49:10 AM UTC+13, Elias Nkiaka wrote:

[Harsh Beria]

Hello everyone,

So, I landed up in a similar problem and resolved it successfully. What you need to do is go to your computer's language settings (in control panel), change the language to English (United States), close ArcGIS, reopen it and reload the project and then try to execute it. This worked for me. If you need any further guidance, please let me know. I will be more than happy to help.

[issam achour]

change it to MM jj aaaa format and it will be done for sure

[Matt Noteboom]

This is rather painful. Any chance it will be updated to read dates properly?

[Willem Vervoort]

Hi,

the people in the US will ague that it does read dates properly :-)

I have found that it depends on how you start up ArcMap, and seems to work both ways, but i haven't worked out a pattern. But yes, it is a bit painful.

Willem

--
You received this message because you are subscribed to the Google Groups "ArcSWAT" group.
To unsubscribe from this group and stop receiving emails from it, send an email to arcswat+unsubscribe@googlegroups.com.
To post to this group, send email to arc...@googlegroups.com.
Visit this group at https://groups.google.com/group/arcswat.
For more options, visit https://groups.google.com/d/optout.

[Matt Noteboom]

True enough. But in my experience when your code asks the computer for the date, you can tell it how you want it which is what I meant by 'properly'.

I didn't mean that d/m/y is "correct" although it's what I'm used to. I generally prefer y/m/d h:m:s for code and timestamps as it will keep things in order forever.

I'd be interested if you work out a pattern. I was at a workshop running through setup and processing on one of the example datasets in ArcSWAT, but with my PC setup to dd/mm/yyyy dates. In that case I wonder if there are mm/dd/yyyy dates in the sample data that clash with the system format...

On Sunday, 11 June 2017 03:40:14 UTC-4, Willem wrote:

Hi,

the people in the US will ague that it does read dates properly :-)

I have found that it depends on how you start up ArcMap, and seems to work both ways, but i haven't worked out a pattern. But yes, it is a bit painful.

Willem

On Sun, Jun 11, 2017 at 4:26 AM, Matt Noteboom <matt.n...@gmail.com> wrote:

This is rather painful. Any chance it will be updated to read dates properly?

On Wednesday, 12 March 2014 21:29:40 UTC-4, Adu wrote:

hi Razna!

You have to change the date format in your computer to US format (mm/dd/yyyy)

Regards,

Adriano

On Monday, March 3, 2014 4:20:39 PM UTC+1, Razna Rahim wrote:

Dear all,

   

                    I am using ArcSWAT 10.1, when I attempt to write SWAT input tables,  I keep getting an error ‘conversion from string “12/31/3000” to type ‘Date’ is not valid’.

     In my input files, I didn't use the year 3000 anywhere, but the error occurs.

 

 How can I overcome this problem?

 

 

Razna

 

--
You received this message because you are subscribed to the Google Groups "ArcSWAT" group.

To unsubscribe from this group and stop receiving emails from it, send an email to arcswat+u...@googlegroups.com.

[Maroof Shaikh]

I was also facing same issue. but I had followed the same procedure which you have mentioned and my problem is solved now. thank you very much Harsh Beria.

[Dorjpalam Od]

Hello Razna did you fix that issue? I am facing that situation now please let me know if you know the solution

Best regards.

[Nancy B. Sammons]

Dorjpalam: 

I would first check that you have your computer set to English units.   Second, this range is set in the master database file (SWAT2012.mdb), in the ‘ciorng’ table.  You can extend the year, save the table and open ArcSWAT again and hopefully the problem will be resolved. 

Nancy

 

 

From: arc...@googlegroups.com <arc...@googlegroups.com> On Behalf Of Dorjpalam Od
Sent: Monday, April 14, 2025 1:17 AM
To: ArcSWAT <arc...@googlegroups.com>
Subject: [ArcSWAT:13806] Re: Error in writing SWAT database tables " conversion from string “12/31/3000” to type ‘Date’ is not valid"

 

You don't often get email from dorjpal...@gmail.com. Learn why this is important

--

You received this message because you are subscribed to the Google Groups "ArcSWAT" group.
To unsubscribe from this group and stop receiving emails from it, send an email to arcswat+u...@googlegroups.com.

To view this discussion visit https://groups.google.com/d/msgid/arcswat/86c78e4e-0c5f-4cc1-a3a2-37c9debd54d1n%40googlegroups.com.

[Farhan Farooq]

Hello , did you happen to fix that issue? I am facing that situation now, please let me know if you know the solution. I tried to have your computer set to English units.   Second, this range is set in the master database file (SWAT2012.mdb), in the ‘ciorng’ table.  You can extend the year, save the table, and open ArcSWAT Best regards.