Date fields include time?

[William Steel]

I just updated to version 4488, and I was trying to do a Find in my Custom Date field which apparently now includes the time as well. Is there any way for me to change it to just the date?

 

 

[Mark J. Castaneda]

I'll point out your observation to the programming team. Does the time cause any trouble with your search?

[William Steel]

Definitely. Any search comes up empty because that field does not have any times listed. I even tried doing a between search for a 24-hour period and still came up empty.

[Mark J. Castaneda]

Pete just released a new build that removes the time from the custom date. Give it a try.

[William Steel]

Sorry it took so long to get back, I downloaded the 4511 build and that seems to have fixed it. Out of curiosity, how did that bug start?

[Steven L. Dasinger]

It wasn't so much a bug as a feature. Some people wanted the ability to do date/time searches.

In setting this up, all date fields (except Cover Date and Street Date where time would make no sense) where changed to Date/Time.

As you (and a few others) found out, this didn't work out so well for Custom Dates (since most would not use time) and they where changed back to just Date.

Other columns where Time will work better are still Date/Time (i.e. Last Modified, Last Qty Change, etc.)