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.
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.
Question
michaeltx
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.