search

CUAHSI / HydroServer

BSD 3-Clause "New" or "Revised" License
8 stars 4 forks source link

Time Series Analyst: error occured in data transfering from character to date #25

Open xhqiao89 opened 7 years ago

xhqiao89 commented 7 years ago

polluxll[CodePlex]
when I finished my hydroserver configuration, and did Tiemseries Ananlyset tool for plotting, I got some errors.The error prompted to say quoterror while plotting data: error occured in data transfering from character to date quot.

xhqiao89 commented 7 years ago

polluxll[CodePlex]
How to solve this problem?

xhqiao89 commented 7 years ago

polluxll[CodePlex]
I used the sample LittleBearRiver ODM database as my test database,I got this error,but when I used ODM tool to plot,there were no error,the date format of TSA Tool was

mm/dd/yyyy,the date format of ODM tool was yyyy-mm-dd

xhqiao89 commented 7 years ago

WaterAnalyst[CodePlex]
I'm starting to think this error is not related to the date formating of your data but more with the System date and time on your computer. My system format is dd/mm/yyyy my data is in format dd/mm/yyyy and I no longer get that error message. I am having issues with the calendar button for selecting dates, it's default is to produce dates in format mm/dd/yyyy. Which produces the 'character to date' error when I use those buttons

xhqiao89 commented 7 years ago

yynian[CodePlex]
hi, I modified the date format tobe dd/mm/yyyy,but I still got the same error,and I send you the error picture.

xhqiao89 commented 7 years ago

WaterAnalyst[CodePlex]
That is the same error I'm getting when using ODMtools, only with different wording. I also get this error when using the TSA tool. The TSA needs the date format to be dd/mm/yyyy but the calendar buttons and the default is in mm/dd/yyyy. The chart is thinking you're trying to input a date in the 15th month or 25th month for example.