You need to sign in to do that
Don't have an account?
Ally Abdool Latiff Mohabuth
Formula date - Format DD/MM/YYYY
Hello,
I am trying to return a date from a text field and i need to have it in the format of DD/MM/YYYY but i am getting it in the form of D/M/YYYY.
For example, for 03/05/2010 i am getting 3/5/2010.
this is the formula i used:
Thank you!
I am trying to return a date from a text field and i need to have it in the format of DD/MM/YYYY but i am getting it in the form of D/M/YYYY.
For example, for 03/05/2010 i am getting 3/5/2010.
this is the formula i used:
TEXT( Day( DateValue( Date_of_Birth__c) ) ) +'/'+ TEXT( MONTH( DateValue( Date_of_Birth__c) ) ) +'/'+ TEXT( YEAR( DateValue( Date_of_Birth__c) ) ), null )
Thank you!
IF( DAY(date__c) < 10, '0'+TEXT( DAY(date__c) ), TEXT( DAY(date__c) ) ) +'/'+
IF( MONTH(date__c) < 10, '0'+TEXT( MONTH(date__c) ), TEXT( MONTH(date__c) ) ) +'/'+
TEXT(YEAR(date__c))
@Vineet your formula needs to be modified to this please have a look your first condition in if should have leading 0 not second also there was a missing bracket.