Forum Discussion

lavdeep's avatar
lavdeep
Icon for Advocate I rankAdvocate I
7 years ago
Solved

How to extract month name from date

HI,   i have colunm where date format "DD/MM/YYYY" i want to extract only month name like this "MMM" formate "Jan"
Need Help
DianaCueca's avatar
DianaCueca
New Member
5 years ago

Hello All,

 

 I'm really new on this. I'm trying to get the month name from two columns using an if function.

 

 I need for example if column "Delivery Type" has "Miami_Xdock" it should bring the month name from column "Leg2 Order Received", if not it should bring month name from Column "Leg1 Actual Delivery Date"

 

 I was trying the two below:

IF(Deliveries_db[Delivery Type]="Miami_Xdock",MONTH([Leg2 Order Received],[Leg1 Actual Delivery Date])) This one didn't work

 
IF(Deliveries_db[Delivery Type]="Miami_Xdock",FORMAT([Leg2 Order Received],[Leg1 Actual Delivery Date])) This one brings only the date for column "Leg1 Actual delivery date" (like the if is not working)
 
Hope you can help!
DianaCueca's avatar
DianaCueca
New Member
5 years ago

Hello All,

 

i just solved it myself. I used the below and works perfect

 

MONTH = IF(Deliveries_db[Delivery Type]="Miami_Xdock",FORMAT(Deliveries_db[Leg2 Order Received],"mmmm"),FORMAT(Deliveries_db[Leg1 Actual Delivery Date],"mmmm"))
 
regards!