Unparseable date?

sconlon · Mar 1, 2012

My app downloads a CSV file from an FTP server and reads a date, eg 27/02/2012, from the first line of the file (I have set the date format to "dd/MM/yyyy") - each line of the file contains 5 fields. It then checks if that date is more than 7 days old using the code below.

Dim dateline(), newdate As String
Dim table1 As List
Dim su As StringUtils

If File.Exists(csvpath,csvFile) Then
table1 = su.LoadCSV(csvPath,csvFile,chrSeparator)
dateline = table1.Get(0)
newdate = dateline(0)
If DateTime.DateParse(newdate) > DateTime.DateParse(curdate) Then

The thing is that when I download the file from one FTP server it works fine but when the same file is downloaded from another server I get a Java.text.ParseException: Unparseable date: "27/02/21012". If I run it in debug mode and check the contents of newdate it seems to be exactly the same in both cases. Any ideas about what could be causing this?

Thanks.
SC

lagore · Mar 1, 2012

The date in your post is unparseable "27/02/21012" not sure if that is your typo or the problem.

sconlon · Mar 2, 2012

That was indeed a typo - the actual date is 27/2/2012.

SC.

Erel · Mar 3, 2012

Maybe there are spaces in the string?

You can call:

B4X:

newdate = newdate.Trim

sconlon · Mar 4, 2012

There are no spaces in the date but I tried your code anyway but it made no difference - still getting the error. I'm completely puzzled!

sconlon · Mar 4, 2012

So I changed the date to "02/03/2012" and it now works fine. Then changed the date back to 27/02/2012 and it still works. So I don't know what was up with the previous incarnation of that date but there must have been something the parsedate didn't like.

Thanks for the suggestions.

Ratna Fang · Dec 23, 2013

hi erel,

i retrieved a date value from a remote mysql database. the value is shown, let's say "1999-03-26 01:24:16" as an example.
as mysql default format, it simply means 26th march 1999, 01:24:16.

i can use the data as string. but i always get this error "java.text.ParseException: Unparseable date: "1999-03-16 01:24:16" (at offset 4)"
when i use this

B4X:

Date1=DateTime.DateParse(DateString)
Time1=DateTime.TimeParse(DateString)

Date1 and Time1 are declared as long, while DateString is declared as string.

is there anyway i can get the date value (in tick or long) and the time value (in thick or long) so i can use it for further date calculation?

or should i use this code?

B4X:

DateTime.DateFormat="yyyy-MM-dd"
                DateTime.TimeFormat="HH:mm:ss"
                Date1=DateTime.DateParse(DateString)
                Time1=DateTime.TimeParse(DateString)
               
                'make a string and other date format
                DateTime.DateFormat="dd-MM-yyyy"
                DateString=DateTime.Date(Date1) & ", " & DateTime.Time(Time1)

but the code is still throw me the same error, unparseable date

klaus · Dec 23, 2013

Try this code:

B4X:

Dim DateString = "1999-03-26 01:24:16" As String
Dim DateTimeTicks As Long
Dim Date_Time() As String
Date_Time = Regex.Split(" ", DateString)
DateTime.DateFormat = "yyyy-MM-dd"
DateTime.TimeFormat = "HH:mm:ss"
DateTimeTicks = DateTime.DateTimeParse(Date_Time(0), Date_Time(1))

Ratna Fang · Dec 23, 2013

many thanks, klaus
that works perfect

gudino jose luis · Apr 25, 2014

Thank...

Unparseable date?

sconlon

Active Member

lagore

Active Member

sconlon

Active Member

Erel

B4X founder

sconlon

Active Member

sconlon

Active Member

Ratna Fang

Member

klaus

Expert

Ratna Fang

Member

gudino jose luis

Active Member

Similar Threads

Unparseable date?

Active Member

Active Member

Active Member

B4X founder

Active Member

Active Member

Member

Expert

Member

Active Member

Similar Threads

Privacy & Transparency

Privacy & Transparency