Apex Code Development You need to sign in to do that
Don't have an account?
sfdc dev 2264 Formula text to date help needed
I need help on the following requirement as follows,
I have a text field called "Latest date" which has values in "March -2017" format
I want another formula field to convert the above text to dd/mm/yyyy format
The date can be 1st of every month
I shouldnt make any changes to the existing field and need this functionality in a new field
Help me how to acheive this
Thanks in Advance
I have a text field called "Latest date" which has values in "March -2017" format
I want another formula field to convert the above text to dd/mm/yyyy format
The date can be 1st of every month
I shouldnt make any changes to the existing field and need this functionality in a new field
Help me how to acheive this
Thanks in Advance
I am providing the apex code that can easily update the fields.
public class TextDate_to_Date { public String dateInTextFormat; public List<Credit_Card__c> ccObj; public Map<String, Integer> map1; public TextDate_to_Date() { dateInTextFormat = null; ccObj = new List<Credit_Card__c>(); map1 = new Map<String, Integer>{'January'=>1, 'February'=>2,'March'=>3,'April'=>4,'May'=>5,'June'=>6,'July'=>7,'August'=>8,'September'=>9,'October'=>10,'November'=>11,'December'=>12}; } public void m1() { ccObj = [Select Id, name, Date_Text_Type__c, Text_to_date_converted_value__c from Credit_Card__c]; for(Credit_Card__c cc : ccObj) { String temp = ''; temp = cc.Date_Text_Type__c; if(temp == null) { continue; } String month = temp.split(',')[0]; String year = temp.split(',')[1]; for(String mm : map1.keySet()) { System.debug('mm : '+mm); if(mm == month.trim()) { month = map1.get(mm) +''; } } if(month != null && year != null ) { String finalDate = month.trim()+'/'+'01'+'/'+year.trim(); date requiredDateFormat = date.parse(finalDate); Credit_Card__c tempObjectForUpdation = new Credit_Card__c(); tempObjectForUpdation.Id = cc.Id; tempObjectForUpdation.Text_to_date_converted_value__c = requiredDateFormat; update tempObjectForUpdation; } } } }Here Credit_Card__c is object where our fields presents.All Answers
try this one:
Thanks,
Ankur Saini
http://mirketa.com
Assuming that your format will not change as "March-2017" use the below formula.
DATEVALUE(TEXT(VALUE(RIGHT(Latest_date__c,4)))&"-"& TEXT(VALUE(CASE(LEFT(Latest_date__c, LEN(Latest_date__c)-5), "January","1", "Febraury","2", "March","3", "April","4", "May","5", "June","6", "July","7", "August","8", "September","9", "October","10", "November","11", "December","12", "3") )) &"-"&"1")Lokesh
I am providing the apex code that can easily update the fields.
public class TextDate_to_Date { public String dateInTextFormat; public List<Credit_Card__c> ccObj; public Map<String, Integer> map1; public TextDate_to_Date() { dateInTextFormat = null; ccObj = new List<Credit_Card__c>(); map1 = new Map<String, Integer>{'January'=>1, 'February'=>2,'March'=>3,'April'=>4,'May'=>5,'June'=>6,'July'=>7,'August'=>8,'September'=>9,'October'=>10,'November'=>11,'December'=>12}; } public void m1() { ccObj = [Select Id, name, Date_Text_Type__c, Text_to_date_converted_value__c from Credit_Card__c]; for(Credit_Card__c cc : ccObj) { String temp = ''; temp = cc.Date_Text_Type__c; if(temp == null) { continue; } String month = temp.split(',')[0]; String year = temp.split(',')[1]; for(String mm : map1.keySet()) { System.debug('mm : '+mm); if(mm == month.trim()) { month = map1.get(mm) +''; } } if(month != null && year != null ) { String finalDate = month.trim()+'/'+'01'+'/'+year.trim(); date requiredDateFormat = date.parse(finalDate); Credit_Card__c tempObjectForUpdation = new Credit_Card__c(); tempObjectForUpdation.Id = cc.Id; tempObjectForUpdation.Text_to_date_converted_value__c = requiredDateFormat; update tempObjectForUpdation; } } } }Here Credit_Card__c is object where our fields presents.run the above class with the help of trigger.
and if your problem is solved then set as a best answer.