Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Need help on Calculation -

Hi All,   Quick help, please   In the client Cyrstal reporting system, the calculation was defined like this,   IF(IRD.RL_Date) = #12/07/2941 12:00:00 AM"# then 0  else Datediff("h",{IRD.Book...
General Comment
Need Help
Show and Tell
  • BA_Pete's avatar
    BA_Pete
    3 years ago

    Hi Anonymous ,

     

    In M code, it would be something like this:

    if [IRD.RL_Date] = #datetime(2941, 07, 12, 00, 00, 00) then 0
else Duration.Hours([IRD.RL_Date] - [IRD.Book_Date])

     

    Pete

BA_Pete's avatar
BA_Pete
Super User
3 years ago

Hi Anonymous ,

 

In M code, it would be something like this:

if [IRD.RL_Date] = #datetime(2941, 07, 12, 00, 00, 00) then 0
else Duration.Hours([IRD.RL_Date] - [IRD.Book_Date])

 

Pete

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Let me try this BA_Pete , Thanks for your update