Kusto Get Next Patch Tuesday.kql

let GetPatchTuesday = (timestamp: datetime) {
    case(
        dayofweek(startofmonth(timestamp) + 07d) == 2d, startofmonth(timestamp) + 07d,
        dayofweek(startofmonth(timestamp) + 08d) == 2d, startofmonth(timestamp) + 08d,
        dayofweek(startofmonth(timestamp) + 09d) == 2d, startofmonth(timestamp) + 09d,
        dayofweek(startofmonth(timestamp) + 10d) == 2d, startofmonth(timestamp) + 10d,
        dayofweek(startofmonth(timestamp) + 11d) == 2d, startofmonth(timestamp) + 11d,
        dayofweek(startofmonth(timestamp) + 12d) == 2d, startofmonth(timestamp) + 12d,
        startofmonth(timestamp) + 13d
    )
};
let patchTuesday = case(GetPatchTuesday(now()) <= now(), GetPatchTuesday(now()), GetPatchTuesday(now() - 14d));