Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Ameya Desai 1Ameya Desai 1 

How to display Month and Year in the custom field from existing date field

Hi,

I have requirement to parse only Month and year from exisiting Date field. I have got formula for month (below) but how to add Year in the formula? Please help

CASE(
MONTH(FirstRespondedDate ),
  1, "January",
  2, "February",
  3, "March",
  4, "Apr",
  5, "May",
  6, "June",
  7, "July",
  8, "August",
  9, "September",
  10, "October",
  11, "November",
  12,"December",
"")
Best Answer chosen by Ameya Desai 1
Boris BachovskiBoris Bachovski
CASE(
MONTH(FirstRespondedDate ),
  1, "January",
  2, "February",
  3, "March",
  4, "Apr",
  5, "May",
  6, "June",
  7, "July",
  8, "August",
  9, "September",
  10, "October",
  11, "November",
  12,"December",
"") + "/" + YEAR(FirstRespondedDate)

 

All Answers

Boris BachovskiBoris Bachovski
CASE(
MONTH(FirstRespondedDate ),
  1, "January",
  2, "February",
  3, "March",
  4, "Apr",
  5, "May",
  6, "June",
  7, "July",
  8, "August",
  9, "September",
  10, "October",
  11, "November",
  12,"December",
"") + "/" + YEAR(FirstRespondedDate)

 
This was selected as the best answer
Ameya Desai 1Ameya Desai 1
Its giving me an error" Error: Incorrect parameter type for function 'MONTH()'. Expected Date, received DateTime"

CASE(
MONTH(Created Date ),
  1, "January",
  2, "February",
  3, "March",
  4, "April",
  5, "May",
  6, "June",
  7, "July",
  8, "August",
  9, "September",
  10, "October",
  11, "November",
  12,"December",
"") &" "&TEXT(YEAR( Created Date ))

Please help!
Ketankumar PatelKetankumar Patel
CASE(
MONTH(Datevalue(CreatedDate)),
  1, "January",
  2, "February",
  3, "March",
  4, "Apr",
  5, "May",
  6, "June",
  7, "July",
  8, "August",
  9, "September",
  10, "October",
  11, "November",
  12,"December",
"")+" "+Text(YEAR(Datevalue(CreatedDate)))
You need to convert your date/time field to date field.  
Ameya Desai 1Ameya Desai 1
Thanks Ketan!!
Ameya Desai 1Ameya Desai 1
Hi All,

One question again for the above formula:

I have requirement to display the same field in mm/dd/yyyy format. The above formula returns in  yyyy/mm/dd. 

Can you please help what modifucation can be done to get the required result.

Thanks,
Ameya
Ketankumar PatelKetankumar Patel
Hi Ameya, 

Try below code. You should replace Today() with your date field. if that field is date/time then you should replace Today() with
DateValue(Your_DateTime_Field__c).  
Text(Month(Today()))+'/'+Text(DAY(Today()))+'/'+Text(Year(Today()))

 
Philipp HahmannPhilipp Hahmann
Thank you a lot Ketan, you helped me a lot with that solution!!