I’m bumping this again up top and adding my specific issue. My function below might help others but something is wrong, it’s not there yet.
So I have a table with European format dates.
I am referencing this data in another table and trying to reformat them into American format so they can be displayed and filtered correctly.
I can get them to display correctly but then filtering by date just doesn’t work. I am confused.
Here’s my function to convert the date. I am getting a Wrong argument type error, is that why I can’t filter. Using ToNumber() doesn’t help, error still says “…which is text”
In any case, the dates display correctly but then if I try a filter like
[Trans Date]=ToDate("2/4/19"), it doesn’t work.
Just figured out that if you add ToText() on the date when filtering, it works…!? Now I am more confused, because both of these work:
Why would filtering using a Date object doesn’t work but when comparing strings it understands which is larger or smaller?