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
Date Format
-
- BronzeLounger
- Posts: 1488
- Joined: 05 Feb 2010, 22:25
Date Format
Last edited by Leesha on 03 Jan 2021, 03:47, edited 1 time in total.
-
- 4StarLounger
- Posts: 550
- Joined: 30 Jul 2014, 23:58
Re: Date Format
Hi, Please take a look at this web site as it explains the procedure.
https://trumpexcel.com/remove-time-from ... g-Formulas
HTH
https://trumpexcel.com/remove-time-from ... g-Formulas
HTH
-
- BronzeLounger
- Posts: 1488
- Joined: 05 Feb 2010, 22:25
Re: Date Format
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
Leesha