Forum Discussion

kasife's avatar
kasife
Helper V
3 years ago
Solved

comparison between columns

Guys,

in the M language, how could I get just the month and year of each column so that I can perform a comparison?

For exemplo: 

   (Column data_alteracao_status)         (CreatedDate)

if               11/2022                          <    10/2022    then null 

I would like to compare month and year only, without full date

 

Need Help
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    in case of no less I wrote "OK". instead you can paste what you want

    if
Number.From(Date.ToText(
Date.From([data_alteracao_status]),[Format= "yyyyMM"])) <
Number.From(Date.ToText(
Date.From([CreatedDate]),[Format= "yyyyMM"])) then null else "OK"

2 Replies

  • Ahmedx's avatar
    Ahmedx
    Super User
    3 years ago

    in case of no less I wrote "OK". instead you can paste what you want

    if
Number.From(Date.ToText(
Date.From([data_alteracao_status]),[Format= "yyyyMM"])) <
Number.From(Date.ToText(
Date.From([CreatedDate]),[Format= "yyyyMM"])) then null else "OK"