'Kusto # Change month's name for their number

I would like to change the month's name for their number, so Mar-> 3 or Jan-> 1.

Kusto image

enter image description here

I thought about replacing, but I think that I use a lot of variables...

Do you have any suggestions?

Regards.

azurekqlazure-log-analytics


Solution 1:[1]

You can use the following in your Formula Tool to Change month's name to their number:

SWITCH([Month], Null(),

"Jan", "01", "Feb", "02", "Mar", "03", "Apr", "04", "May", "05", "Jun", "06", "Jul", "07", "Aug", "08", "Sep", "09", "Oct", "10", "Nov", "11", "Dec", "12" )

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 RajkumarMamidiChettu-MT

Related Questions