Access Export to Text Date/TimeFormat Question

[smurfer]

I have a table that I am trying to export to a text file, it contains a date time field, i.e 12/12/2001 11:15 is what is shown in the DB. However although my input mask allows only an hh:nn input, when I export this to a text file, it pulls over seconds as well which I can not have. Is it possible to change this, I can not find anything within the export "advanced" options, can anyone help??
Thanks,
SM

 

[raskew]

You might try this to construct your text field:

? format$(now(), "short date&quot & " "& format$(cdbl(now())- int(cdbl(now())), "hh:nn&quot