I have a database with hourly temperature values that I'm trying to extract a range of data "between" to dates. The data file looks like:
Date Time Temp
01-Jan-02 0:00 29.9
01-Jan-02 1:00 30.3
01-Jan-02 2:00 29.9
01-Jan-02 3:00 29.9
I'm trying to use the Advanced Filter with the following Criteria range:
Date Time Temp
>=37319 (= 3/4/02)
<=37325 (= 3/10/02)
I works if I reverse this and "exclude" data between the two dates or only search in one direction.
What am I doing wrong? I'd like to eventually create a VBA so the user simply enters two date to extract all the data "between" the two timepoints.
Thanks in advance.
Date Time Temp
01-Jan-02 0:00 29.9
01-Jan-02 1:00 30.3
01-Jan-02 2:00 29.9
01-Jan-02 3:00 29.9
I'm trying to use the Advanced Filter with the following Criteria range:
Date Time Temp
>=37319 (= 3/4/02)
<=37325 (= 3/10/02)
I works if I reverse this and "exclude" data between the two dates or only search in one direction.
What am I doing wrong? I'd like to eventually create a VBA so the user simply enters two date to extract all the data "between" the two timepoints.
Thanks in advance.