NearImpossible
Registered User.
- Local time
- Today, 09:30
- Joined
- Jul 12, 2019
- Messages
- 225
I have a table that is storing the date and time that a transaction occurs in the following format "10/20/2019 5:57:11 PM"
I am trying to do a "Start" and "End" range search with
>=[forms]![TransferHistoryReports]![StartDate] for the start string And <=[Forms]![TransferHistoryReports]![EndDate] for the end string in my query.
My first transactions were done on 10/20/19 so If I enter a start date of 10/1/19 and end date of 10/20/19, nothing returns, however if I use an end date of 10/21/19, I get all the transactions from 10/20/19.
I am guessing this is due to the time being included in the stored value and not being entered in the search value.
As this report would need to include everything from 0:00:00 on the Starting Date through 11:59:59 on the End Date, i'm not sure how to include that in my query to make it work correctly.
Any help is appreciated, thank you
UPDATE: I am actually storing the Date/Time the first transaction occurred, as well as the last in separate columns so the table columns i'm use are TransferToDate and TransferFromDate and the query is >=[forms]![TransferHistoryReports]![StartDate] for the TransferToDate and <=[Forms]![TransferHistoryReports]![EndDate] for the TransferFromDate
I am trying to do a "Start" and "End" range search with
>=[forms]![TransferHistoryReports]![StartDate] for the start string And <=[Forms]![TransferHistoryReports]![EndDate] for the end string in my query.
My first transactions were done on 10/20/19 so If I enter a start date of 10/1/19 and end date of 10/20/19, nothing returns, however if I use an end date of 10/21/19, I get all the transactions from 10/20/19.
I am guessing this is due to the time being included in the stored value and not being entered in the search value.
As this report would need to include everything from 0:00:00 on the Starting Date through 11:59:59 on the End Date, i'm not sure how to include that in my query to make it work correctly.
Any help is appreciated, thank you
UPDATE: I am actually storing the Date/Time the first transaction occurred, as well as the last in separate columns so the table columns i'm use are TransferToDate and TransferFromDate and the query is >=[forms]![TransferHistoryReports]![StartDate] for the TransferToDate and <=[Forms]![TransferHistoryReports]![EndDate] for the TransferFromDate
Last edited: