Android Question Stupid DATE question...

[krzyszp]

Hi,

I'm using query to get records with current date from database.
Now I need to get Yesterday date (now - 1).
What is simplest way to get yesterday date in string variable?

Currently my query looks like:

"Select * FROM table WHERE (CHID = " & Main.iUserID & " OR CHID = 0) AND InDate  = '" & sToday & "' AND (Completed is null or Completed = 0)"

Where Today is current day in format "yyyy-MM-dd".

 

[Erel]

You should use a parameterized query (ExecQuery2).

Dim p As Period
p.Days = -1
Dim yesterday As String = DateTime.Date(DateUtils.AddPeriod(DateTime.Now, p))

Make sure to add a reference to DateUtils.

 

[krzyszp]

Thanks.
This is exactly what I need