Jump to content
  • 0

Date Range Feature Not Working Properly


michaeltx

Question

I created a datapage that allows a user to search for information based upon a date range. For begin date I used "Greater than or equal to" and for end date I used "less than or equal to". Here is an example of a search that does not yield an accurate response.

 

I enter the following information as my search parameters:

Begin Date: 12/15/2014

End Date: 12/16/2014

 

The system will return only the records dated 12/16/2014. However there are records dated 12/15/2014 that are not returned. I double checked to make sure that the data resides in my table and it does with the correct date in the same format as all of the other days.

 

Also if I query today's date (12/23/2014) it will not return any results although the data exists. I query today's date by entering the following:

Begin Date: 12/23/2014

End Date: 12/23/2014

 

I don't know what I'm doing wrong, but if you have some thoughts, please share them as I do need some help. I've tried everything I can think of. BTW...my data page is a report and chart combined.

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...