Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
stekol61
Creator
Creator

Month as numerical

Hi!

I need to have two month format in my app. 

Month name, e.g Jan, Feb etc in my graphs and numerical month in my filter.

I used these expressions and I want 'Month_cal' to be a numerical value between 1 and 12

Month(event_start_date)as Month

Month(event_start_date)as Month_cal

1 Solution

Accepted Solutions
Somasundaram
Creator III
Creator III

Use this,

Num(Month(event_start_date))as Month_cal


-Somasundaram

If this resolves your Query please like and accept this as an answer.

View solution in original post

1 Reply
Somasundaram
Creator III
Creator III

Use this,

Num(Month(event_start_date))as Month_cal


-Somasundaram

If this resolves your Query please like and accept this as an answer.