I think this is not possible through Standard fields and formulas,
But you can do this with VFP and APEX.
Am sharing code here you can use this IF needed/useful to you
Apex Class
public class MyControllerdate {
public Task DateInput {get;set;}
public string sFormattedDate {get;set;}
public MyControllerdate() {
DateInput = new Task();
}
public void save() {
Date dInputDate = DateInput.ActivityDate;
//Format Date
DateTime dtValue = DateTime.newInstance(dInputDate.year(), dInputDate.month(), dInputDate.day());
sFormattedDate = dtValue.format('yyyy-MM-dd');
}
}
Its possible through regular formula, just took a little more research. Here is the solution:
(IF(ISBLANK(Complete_Date__c), "",
TEXT(YEAR(Complete_Date__c))+"/"
+TEXT(MONTH(Complete_Date__c))+"/"
+TEXT(DAY(Complete_Date__c))))
All Answers
Hi,
I think this is not possible through Standard fields and formulas,
But you can do this with VFP and APEX.
Am sharing code here you can use this IF needed/useful to you
Apex Class
VFP Code
Its possible through regular formula, just took a little more research. Here is the solution:
(IF(ISBLANK(Complete_Date__c), "",
TEXT(YEAR(Complete_Date__c))+"/"
+TEXT(MONTH(Complete_Date__c))+"/"
+TEXT(DAY(Complete_Date__c))))
hi,
This one is Good and Thanks for Sharing this..