GetDate Problems

  • Thread starter Thread starter mpaynter
  • Start date Start date
M

mpaynter

I have just connverted a DB to SWL backend with access as the front end

I am having problems with returning Date functions

I have a column that I wish to return the date format dd/mm/yyyy and
time column that I want return 00:00 I have tried using the getdate(
command with the column as a date/time column but this returns date an
time. can anyone help as my access queries won't work if you search fo
date()

Cheer
 
Hi,

Why you don't keep the date AND time, then, outside the query, FORMAT
appropriately?



Vanderghast, Access MVP
 
Back
Top