Calculating Days between Dates

mickeymurray

Sat, 04/10/2021 - 01:24

Forums

General discussion

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.

You have to add @ctod around

Brian Element Sat, 04/10/2021 - 08:49

You have to add @ctod around it. So do @ctod("20190331", "YYYYMMDD") and that should fix the problem.

I am still getting an error.

mickeymurray Sat, 04/10/2021 - 12:50

I am still getting an error. I have attached the screenshot. Thank you for your help.

Hi MIckey,

Brian Element Sun, 04/11/2021 - 16:19

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)

Forums

You have to add @ctod around

I am still getting an error.

Hi MIckey,

Share This Page