How can I set multiple variables inside a KQL iff statement?

Tyler 1 Reputation point

I have an SQL statement like this:

if @stopDate is null  
  set @stopDate=dateadd(day,-1,convert(date,getdate()))  
  set @startDate=dateadd(day,1,dateadd(month,-1,@stopDate))  

How can I convert this to KQL? I can set one variable fine, but I'm not sure how to do two.

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
266 questions
No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Maxim Sergeev 6,386 Reputation points Microsoft Employee

  2. ShaikMaheer-MSFT 30,041 Reputation points Microsoft Employee

    Hi @Tyler ,

    Thank you for posting query in Microsoft Q&A Platform.

    You can consider writing code as below in this case.

    let stopDate = iif(testBool, dateadd(...), <something else>);  
    let startDate = iif(testBool, dateadd(...), <something else>);  

    Hope this helps. Please let me know if any further queries.


    Please consider hitting Accept Answer button. Accepted answers help community as well.