Forum Discussion

Musketeers's avatar
Musketeers
Frequent Visitor
10 years ago
Solved

if else condition with between operator

Hi, I am using M language and adding a new column in table. I need to write if condition in this line. I am writing if condition like this: if [Month] between 2 and 4 then "yes" else "no"   Now...
Need Help
  • donsvensen's avatar
    donsvensen
    10 years ago

    Hi

     

    You can do this

     

    if [Month] >= 2 and [Month] <= 4 then "yes" else "no"

     

     

     

    /Erik

Musketeers's avatar
Musketeers
Frequent Visitor
10 years ago

Hi Simon, Thanks for your suggestion. Yes that way it is working. Thanks all for your time and suggestions.

osiel's avatar
osiel
Frequent Visitor
8 years ago

hello, it still works so I've tried and it does not work for me the only thing is that I'm using dates and looking for a date within this range, for example:

Start date: 01-01-18
Final Date: 08-01-18
date to search: 05-01-17
if the date is within the range that returns me a value of $ .100.
thanks for your comments. regards osiel