How to use filter Date time between 2 fields

Bubu, after very brief testing, I'm not positive that Jet Essentials is successfully converting the result of this code:
TEXT($E13,"MM/DD/YYYY")&" 01:30:00 PM

into a Date Value.

Try encapsulating ALL of that with a Value() function.

Value(TEXT($E13,"MM/DD/YYYY")&" 01:30:00 PM)

This will convert your text string into an Excel serial number Date value.


Please sign in to leave a comment.