find month year

[inam]

Hello Community,

I have column "Check_in" in this date feild

05-09-2023
22-08-2023
28-10-2023
10-12-2023
04-11-2023
03-10-2023
30-09-2023
12-11-2023
20-10-2023
14-08-2023
18-01-2024
01-11-2023
26-08-2023
04-01-2024
01-02-2024
14-08-2023
15-08-2023
12-11-2023
12-11-2023
25-08-2023
05-09-2023
22-08-2023
28-10-2023
10-12-2023
04-11-2023
03-10-2023
30-09-2023
12-11-2023
20-10-2023
14-08-2023
18-01-2024
01-11-2023
26-08-2023
04-01-2024
01-02-2024
14-08-2023
15-08-2023
12-11-2023
12-11-2023
25-08-2023
22-09-2023

i want month year column like jan-2023,feb-2023,march-2023, jan-2024 etc 

expected output below :- 

jan-2023

feb-2023

mar-2023

apr-2023

may-2023

jun-2023

jul-2023

aug-2023

sep-2023

oct-2023

nov-2023

dec-2023

jan-2024

feb-2024

mar-2024

[Rahul_Athavale · Accepted solution]

Hi,
You can use Monthname function.
you can use below expression:-
Monthname(FieldName)

[inam]

Thanks @Rahul_Athavale 😊 working fine now 

[inam]

Hello @Rahul_Athavale  

I have one another doubt .

i am taking month feild in dimension but i want current month to 6 month only 

=Sum({<MONTH1={"$(=Date(AddMonths(Today(),6),'MMM YYYY'))"}>} [Invoiced amount (no VAT)]) i am using this but its not work .please can you help me 

[Rahul_Athavale]

if you want sum of [Invoiced amount (no VAT)] for previous six months only then

Sum({<New_Date={">=$(=date(AddMonths(Max(Date_Field),-6),'DD/MM/YYYY'))<=$(=date(Max(Date_Field),'DD/MM/YYYY'))"}>}salary)

[mikemiler]

Looking to the future with mobile app development services, we can expect further integration of AI and machine learning for predictive analytics, the adoption of 5G for real-time data sharing, and a focus on sustainable, eco-friendly warehousing practices.