Remove time from Date/Time column?

[mckeever]

Hello,

How can I remove the time string from a Date/Time column in my Table? It is separated from the date by a space. Thank you.

 

[LittleSmudge]

You don't.

If you have a field in your table that is of data type Date then that field holds the date and the time.

However, If you really mean "How do I get it to DISPLAY just the Date on a Form or Report ?"
Then just set the Format of the control to "Short Date"



'ope-that-'elps.

G LS

 

[mckeever]

I can't believe it could be that easy. So, when I import my Excel sheet (which has the time stamp), do I remove it first or just let the table "short date" property take care of it upon import? Thank you very much for your first answer.

 

[LittleSmudge]

PERSONALLY .. .. I'd leave the full detail of the data in the TABLE - you never know when you might want to use it in the future.

I'd do nothing with the table "short date" as you put it.

If you don't want the TIME portion displayed on the screen use the formatting in the control on the Form or Report.

G LS