OR condition on two date variables

[Cho8]

Hi,

Iam getting error for the below condition

where (REQD_DT between '01APR2020'd and '31MAR2021') OR (date1 between '01APR2020'd and '31MAR2021'd)

ERROR: WHERE clause operator requires compatible variables

what is the correct code to compare two date variables with fixed date intervals.

[Cho8]

Hi,

Iam getting error for the below condition

where (REQD_DT between '01APR2020'd and '31MAR2021') OR (date1 between '01APR2020'd and '31MAR2021')

ERROR: WHERE clause operator requires compatible variables

what is the correct code to compare two date variables with fixed date intervals.

[andreas_lds]

---

@Cho8 wrote:

where (REQD_DT between '01APR2020'd and '31MAR2021'd) OR (date1 between '01APR2020'd and '31MAR2021'd)

---

Now the d is/was missing after each '31MAR2021'-string.

[andreas_lds · Accepted solution]

There is a "D" missing after the first '31MAR2021'.