PDA

View Full Version : date_format?

jayson_13
09-03-03, 07:10
hi,

how can i format date in the format i want?
i want to do something like this:
select invoice#, amount from invoice where invoiceDate >= date_format(31/08/2003, "dd/MM/yyyy")

i am using vb to connect to paradox that is y i need to contruct sql statement into something like this.
thanks!
Maroonotmoron
09-15-03, 18:31
If you mean the default date display, it is a BDE setting.

MODE: Controls the order of the month, day, and year components. Set it to
0 : (for MDY)
1 : (for DMY)
2 : (YMD)

You can also set up leading zero's and four digit year in the BDE setting.

Access via control panel.
Maroonotmoron
09-15-03, 18:38
If you only need to format the date on the fly then the command would be:
format("DO(%D/%M/%Y)",da)

Place the DMY in the desired order.