Categories
how to for date in between

hello everyone,
I have a calendar column and was trying to achieve the following.
can anyone help me as I am having the Formula syntax is invalid.
case
when "Sale Date (Calendar)" is between ('01-04-2021, 31-03-2020') then "A"
when "Sale Date (Calendar)" is between ('01-04-2020, 31-03-2021') then "B"
End
Thank you
Answers
-
Hi,
The BETWEEN comparison has the following syntax:
xxx BETWEEN value1 AND value 2
Write your CASE WHEN with this syntax and you should be getting there. If your presentation column is a real date, you should also compare it to dates and not strings.
0 -
a) Your references to presentation columns are wrong. A correct fully qualified name is "Presentation Table"."Presentation Column".
b) Date data types are dates. Not strings. Using single quotes denotes a string. '
c) "A" isn't the string A - 'A' is the string A, see above. Single quotes and double quotes can't be utilized randomly. They have technical and programmatical meaning.
0