Display values of two different dates.

[Richard3]

I need to compare the value of what was produced on a date this year against the value of what was produced on the same date but last year.
That is, I have a date table and an amount table and I want to know how much is the amount for 08/01/2022 and how much is the amount for 08/01/2021.

[sidhiq91 · Accepted solution]

@Richard3  You can write something like below: since you are specifically asking 08/01/2022 and 08/01/2021. It can written as below:

Table:

Load Date_Field,

       Amount

from table_name

where Date_Field=Date(Today()-2,'MM/DD/YYYY') or Date_Field=Date(Addyears(today()-2,-1),'MM/DD/YYYY');