date problem

[zedan]

Hi
i want to use the following Qry
select format(date , "ddmmyy")
from sales
but i got this MSG
<Message> in query expression <expression>. (Error 3075)
The expression you typed is not valid for the reason indicated in the message. Make sure you have typed field names and punctuation correctly, and then try the operation again.

Note : im using MS. Access Xp

thanks

[Madhi]

Which database are you using?

[Naumaan]

look at the following query

SELECT format([from_date],"ddmmyy")
FROM symbol_spot_schedules;

here from_date is the column and symbol_spot_schedules is the table.

[srikanthvja]

hi,

if your r using msaccess.

try this...exmple

select format( start_date,"ddmmyy") START_DATE, format( now,"ddmmyy") todaydt from TableNaME

if your using oracle

SELECT to_char(sysdate,"DDMMYY") FROM DUAL

Enjoy VB programming.........
all the best