Hi! I need to calculate the days between the field date and 3/31/2019. I am trying to do this in Equation Editor and cannot use the @Age function. I entered in the following: "20190331" - INVOICE_DATE and the equation error "mismatch field type" is showing up. Any help would be appreciated.
mickeymurray
Offline
Last seen: 2 years 11 months ago
Joined: 04/10/2021 - 01:19
You have to add @ctod around it. So do @ctod("20190331", "YYYYMMDD") and that should fix the problem.
I am still getting an error. I have attached the screenshot. Thank you for your help.
Hi MIckey,
That is because what I gave you was only for the date field. If you are using the @age the entire function would be something like this:
@age(@ctod("20190331", "YYYYMMDD"), INVOICE_DATE)