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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access pass-through query, SQL-92 combining strings: '&' does not 4
Cdate funtion inconsistency 4
Query to get information that doesn't match by date 2
Formatting date gives bad results in query 2
Converting a Date 2
Date/time query 1
Exporting Date includes 0:00:00 - Don't Want That! 6
How to Calculate Business Days and Hours? 1

Back
Top