Salesforce formula help needed

Hi,

I need help on the following requirement as follows,

I have 2 fields called "Latest date" and "Latest date 1"

I have a formula which would convert a text to a formula text

for eg : March-2017 would be stored as 01/03/2017

it works fine but my issue issue

if "Latest date" which holds March -2017 values if its null

then the next field "latest period date 1" is having some incorrect format like 1/01 which should also be null

help me how tyo fix it

Thanks in Advance

MY FORMULA :


"01/"+CASE(UPPER(LEFT(Latest_Period_Date__c, FIND("-", Latest_Period_Date__c)-1)),
"JANUARY","01",
"FEBRUARY","02",
"MARCH", "03",
"APRIL", "04",
"MAY", "05",
"JUNE","06",
"JULY","07",
"AUGUST","08",
"SEPTEMBER","09",
"OCTOBER","10",
"NOVEMBER","11",
"DECEMBER","12","0")+"/"+RIGHT(Latest_Period_Date__c,4)

May 29, 2017
·
Like
0
·
Follow
1

Best Answer chosen by sfdc dev 2264

GulshanRaj
Hi,

Please use below formula:

IF(ISBLANK(Latest_date__c) ,'',("01/"+CASE(UPPER(LEFT(Latest_date__c, FIND("-", Latest_date__c)-1)), "JANUARY","01", "FEBRUARY","02", "MARCH", "03", "APRIL", "04", "MAY", "05", "JUNE","06", "JULY","07", "AUGUST","08", "SEPTEMBER","09", "OCTOBER","10", "NOVEMBER","11", "DECEMBER","12","0")+"/"+RIGHT(Latest_date__c,4)))

This will work..

Thanks
Gulshan Raj

May 29, 2017
·
Like
0
·
Dislike
0

This was selected as the best answer

sfdc dev 2264
Thanks gulshan again

May 29, 2017
·
Like
0
·
Dislike
0

You need to sign in to do that.

Need an account? Sign Up

Have an account? Sign In

Dismiss

Browse by Topic

Welcome to Support!

Show

sorted by

Salesforce formula help needed

All Answers

You need to sign in to do that.