Forum Discussion

al1981's avatar
al1981
Icon for Helper II rankHelper II
2 years ago
Solved

between date - custom row wiht data type issue

I have Date table with Date column with Date format. Issue i have is that i cannot use this Date column in bellows custom formula (Expression.Error: We cannot apply operator < to types Number and Dat...
al1981's avatar
al1981
Icon for Helper II rankHelper II
2 years ago

hi HotChilli 

 

can you please... tell me what i am missing for custom column? It`s driving me crazy .-)

 

if [Date start] > #date(2022, 9, 30) and < #date(2023, 4, 1) then "C1_22_23"
else
if [Date start] > #date(2023, 3, 31) and < #date(2023, 10, 1) then "C2_22_23"
else
if [Date start] > #date(2023, 9, 30) and < #date(2024, 4, 1) then "C1_23_24"
else
if [Date start] > #date(2024, 3, 31) and < #date(2024, 10, 1) then "C2_23_24"
else null