iOS Question Get the tick value of a date string

[ciginfo]

Is this code right? I want to obtain the tick value of a date "Thedate" registered in a database as date (AAAA-MM-JJ). It seems it does not work.
What is the the syntax of "DateTime.DateTimeParse(Mydate,"")" if I want only date and not time. (I have not time in the database)

Dim  Mydate, Newdate, As Long
Mydate = M.Get("Thedate")
DateTime.DateFormat="AAAA-MM-JJ"
DateTime.TimeFormat="H:mma"
Newdate = DateTime.DateTimeParse(Mydate,"")

 

[Erel]

You should use DateParse if there is no time component. However your date format pattern is wrong. The pattern is described here: http://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html

You are probably looking for: yyyy-MM-dd (note the case).

 

[ciginfo]

No found DateParse at : http://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html and the correctes code below does not work.
An idea?

Dim  Mydate, Newdate, As Long
Mydate = M.Get("Thedate")
DateTime.DateFormat="yyyy-MM-dd"
Newdate = DateTime.DateParse(Mydate)

Thank you

 

[Erel]

DateParse is a B4i method. It will not appear in Oracle documentation. I posted the link so you can read more about the date format patterns.

What is the problem with the code you posted?

 

[ciginfo]

Error parsing: 2015
See on attached image

 

[klaus]

In your code you define DateDebut as a Long.
Then you use TheDateDebut = DateTime.DateParse(DateDebut).
But DateTime.DateParse(DateDebut) expects a String and not a Long.
Put a breakpoint in line 204 and look at DateDebut.

 

[ciginfo]

In fact, DateDebut is in my database phpmyadmin as a date (yyyy-MM-dd). There is not variable as date in B4i and i don't know if i have to consider DateDebut as a long or as a string. It seems i have to consider as a string.

 

[klaus]

As your date is in yyyy-MM-dd format you must consider it as a string.