You need to sign in to do that
Don't have an account?
Scott Janis 20
month(ScheduleDate) onlly works sometimes?
I have a very simple formula so I can render the Schedule Date down to the actual Month. However, there are 175 instances where even though the schedule date is clearly a specific month, the formula is rendering a 'NONE' output meaning the month does not numerically line up with a specific MONTH.
API Name of the field in the line item schedule objct=Schedule_Date_Month_NAME__c
CASE(MONTH(ScheduleDate),
1, "January",
2, "February",
3, "March",
4, "April",
5, "May",
6, "June",
7, "July",
8, "August",
9, "September",
10, "October",
11, "November",
12, "December", "None")
API Name of the field in the line item schedule objct=Schedule_Date_Month_NAME__c
CASE(MONTH(ScheduleDate),
1, "January",
2, "February",
3, "March",
4, "April",
5, "May",
6, "June",
7, "July",
8, "August",
9, "September",
10, "October",
11, "November",
12, "December", "None")
Can you share more details?
Thanks,
Vinay Kumar
Use API name in your formula,Go to Insert field and then select field you want to insert:
CASE(MONTH(Schedule_Date_Month_NAME__c),
1, "January",
2, "February",
3, "March",
4, "April",
5, "May",
6, "June",
7, "July",
8, "August",
9, "September",
10, "October",
11, "November",
12, "December", "None")
Thanks!
If it's Date/Time use like this:
MONTH(DATEVALUE(Schedule_Date_Month_NAME__c))