Solved Removing time stamp from "Date/Time" Fields

[Bean Machine]

Hi All! I'm having trouble removing the time on a date/time field in a table. I want to use "mm/dd/yyyy" format but every time I try to make use of the format it adds a time to the field as well. I have tried looking around for solutions (perhaps I'm not looking hard enough) but its getting really frustrating as this seems like something that should be simple. I appreciate any help in the matter!

 

[theDBguy]

Hi. How exactly are you populating the field? If you have Now() set as the Default Value, change it to Date() instead.

 

[Bean Machine]

Oh my gosh I can't believe I forgot about that... Will do, and thanks for the help! Had similar troubles a long time ago, my mistake, sometimes its the simple things I forget to remember.

 

[theDBguy]

Oh my gosh I can't believe I forgot about that... Will do, and thanks for the help! Had similar troubles a long time ago, my mistake, sometimes its the simple things I forget to remember.

Happens to the best of us. Good luck with your project.

 

[Isaac]

FWIW I like to err on the side of caution and capture time values in almost all of my systems. It's easy to strip off the time portion of stored data later on, but it's awfully hard to go back in time and capture it! More than a few times I've thought I would never need it, but ended up (after a while) some reason would come up why I did, so from then on I kind of just fell into the habit of most always capturing it, even when seemingly unnecessary.

 

[Isaac]

Yeah I was just chuckling thinking about how, I can remember that the most common thing that seems to come up for me with respect to the value of the time capture doesn't even have to do with any core purpose of the app! It's just that it helps ME, as a dev, during the first few weeks/months of its usage (when I am typically still solving problems, troubleshooting things, or having to 'explain' why 'this' or 'that' happened like so)....... It helps me a lot to see "Ahh...Such and such user marked that record in that way at 1:15 PM, which explains why such-and-such other thing happened at 1:16 PM (or whatever the case may be). Gives a lot of behind the scenes insight into app usage and, since i'm an imperfect developer who makes mistakes, helps me catch them and figure things out, honestly