Forum Discussion

i820017's avatar
i820017
Resolver II
4 years ago
Solved

DATESBETWEEN Issue

I am creating a calculated column from 2 other columns in my app, and I am getting this error.     Why I am getting this error? and how can I fix it?    
Need Help
  • HotChilli's avatar
    HotChilli
    4 years ago

    Thanks, very succinct answers.  I'm not used to it.

    Right, so DATESBETWEEN returns a column of dates and that's why it is used with a Dates table (not  a Fact table).  It's also usually used with a measure not a column.

    So, if we try and solve all issues here with DATESBETWEEN, I don't think we're going to achieve anything.

    I think you are trying to test if the PTO_Calendar[End_date_repeat] is in the period of January 2022.  Is that right?

    If so, you can remove the DATESBETWEEN and just use YEAR and MONTH functions to test.

    Let me know.

i820017's avatar
i820017
Resolver II
4 years ago

Here are the answers to your questions:

1. PTO_Calendar[End_date_repeat] is a date column that contains duplicates.

2. PTO_Calendar is a Fact Table.

3. I just switched 2nd and 3rd parameters to date expressions as seen below.