Using an "actual date" in a formula for a calculated column
I thought this would be straight forward, but it's not. I need to put an actual date into a formula as a filter. I don't know the format to use for dates in this instance and I'm thinking that must be the problem.
It's giving me all of the units rather than the portion that fall after the date. As a double check, I used the side-bar filter for that visual and put "after 04/06/2020" in the advanced filter for the InvDate field and got the correct amount, so I know that the date field is formatted as a date field and can be filtered as such.
I'm guessing that the way I entered the date into the formula is wrong. Has anyone come across this?