Date Format

Leesha
BronzeLounger
Posts: 1484
Joined: 05 Feb 2010, 22:25

Date Format

Post by Leesha »

Hi,
I have a user that imports a spreadsheet each month into the database. Two of the columns contain date fields that appear as short date format but when double clicked contain the time. I've tried changing the format in the spreadsheet but have had no success. When the date is pulled into the DB it retains the time even though the field is set to short date format. I would like the time portion eliminated. What is the best way to go about this?
Thanks,
Leesha
Last edited by Leesha on 03 Jan 2021, 03:47, edited 1 time in total.

User avatar
burrina
4StarLounger
Posts: 550
Joined: 30 Jul 2014, 23:58

Re: Date Format

Post by burrina »

Hi, Please take a look at this web site as it explains the procedure.
https://trumpexcel.com/remove-time-from ... g-Formulas
HTH

Leesha
BronzeLounger
Posts: 1484
Joined: 05 Feb 2010, 22:25

Re: Date Format

Post by Leesha »

Thanks! I did try changing the format as suggested, both in Excel and Access but it didn't work, which was odd because I've not had this problem before. I actually just fixed this on my own (yay) using an update query with Format([installdate],"Short Date") and it worked!
Leesha

User avatar
burrina
4StarLounger
Posts: 550
Joined: 30 Jul 2014, 23:58

Re: Date Format

Post by burrina »

Congrats !