Search results

As a side note, you wouldn't believe how many text fields they have for saving dates in this DB. It's no wonder I've been so frustrated trying to get anything to work properly with them. It seems so clear now. Thank you to everyone who helped on this learning experience. I am grateful.

You are a genius! I am an idiot. I used the wrong code in the wrong area. now works perfect. here is the completed query which is now working seamlessly finding all matching dates in all fields. SELECT * FROM DETAILS WHERE (((DETAILS.PaymentDate)>=Date() And (DETAILS.PaymentDate)<Date()+1))...

Yourdate between cast( floor ( cast ( getdate() as float ) ) as datetime ) and cast( floor ( cast ( getdate() as float ) ) as datetime ) + cast ('23:59:59' as datetime) tried... PaymentDate between cast( floor ( cast ( getdate() as float ) ) as datetime ) and cast( floor ( cast (...

DateValue() did not work. I was wrong. I got excited and posted too quickly. As for times, I had thought the times were not being introduced into the system. I still don't think they are, but it seems maybe it simply wasn't showing me the times saved on the SQL server. The original query...

That makes sense. The fields didn't show a time, even though it was there due to formatting. I thought I had it yesterday, which worked on testDB but not on SQL. I will try your code today and hopefully, we'll have a working prototype by noonish. Any other suggestions are greatly appreciated...

fixed. use DateValue() instead of Date() to get just the date and not date/time.

would it make a difference if the test DB uses Access and the real DB uses MSSQL?

You are right though. I created a quick sample DB using the same fields and the query worked fine. It pulled three records, each having todays date but in differing columns. Well, at least I know the query works...now to track down this new issue.

The time element was one of my first thoughts and after reviewing the data itself I can say that there is no field which includes the time, they are formatted for shortdate, which seems to insert just the date but not time. As for text dates, it's works fine, just no date functions per se. The...

The table structure is simple, ID, First_Name, Last_Name, PaymentDate, PaymentAmount, PaymentDate1, PaymentAmount1 etc... through PaymentDate11, PaymentAmount11, Status ID is autonumber First & LAst Name are both TEXT PaymentDates are all date fields with short date formatting. PaymentAmounts...

This is why I absolutely love PHP/MySQL as opposed to Access/MSSQL. Unfortunately that is not an option here. Brian, it's ok man. Anyone else have any ideas or thoughts? At this point I'm ready to change the entire table to TEXT fields, just to make this a hundred times easier. Who would...

I tried your revised code, although it is much cleaner, it produces the same results. It pulls the record with a matching date in the first field, but no files with matching dates in any of the other 11 fields.

I wasn't clear enough I think. Although your method would pull results, it would not pull results based on today's date. The idea here is to find all records with a field that matches today's date. There are 12 fields, each containing a specific date or as you guessed, a null value. But if the...

I've been banging my head on the desk today. The Boss wants a report based on a payments table which includes, 12 date fields. The query should return data for any record which has a match in any of these fields. <code>SELECT * FROM DETAILS WHERE (((DETAILS.PaymentDate) Like Date())) OR...