VB Forum / Database Access / June 2009

Database = SQLite

I'm really pulling my hair on this one.

Here is my current SQL statement:

"SELECT date(Date,'start of month','+1 month','-1 day') as Date, " & _
               "First(Open,ID) as Open, Max(High) as High, " & _
               "Min(Low) as Low, Last(Close,ID) as Close, 0 as
IsSwingTop1, 0 as IsSwingBtm1, " & _
               "0 as IsSwingTop2, 0 as IsSwingBtm2, Null as Delta1,
Null as Delta2, " & _
               "0 as Offset1, 0 as Offset2 FROM [" & sTable & "]
GROUP By Year, Month"

The field of concern is the Date field.

This correctly gathers data Grouped by 'month' and references each
record by the LAST DAY OF EACH MONTH.

2009-01-31
2009-02-28
2009-03-31
2009-04-30
...

However, I'd like to have the date field show up as either

mm/dd/yyyy or dd/mm/yyyy, depending on the date format of the
computer.

How is this accomplished?

Thanks in advance.

Webbiz