Forum Discussion

i820017's avatar
i820017
Icon for Resolver II rankResolver 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.

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
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
    Icon for Resolver II rankResolver II
    4 years ago

    Thanks!!...Using Month and Year worked.