Skip to main content
Topics#Data ManagementFrage von Libby Posadas
Libby Posadas (Curve Securities) fragte in #Data Management
9. Mai 2017, 06:02

What is my formula changing the date format of my date field?

I am creating a field update (naming convention) formula and it is returning the date field I have included (which is in date data type) as YYYY-MM-DD, when it appears on the record page as DD/MM/YYYY.

 

Can someone provide some guidance? Do I need to add a direction for the date output format?

 

This is the date part of my formula: 

 

+ TEXT(Maturity_Date__c)

 

Thanks!
4 Antworten
  1. Gulnawaz Aamir (Private)
    9. Mai 2017, 06:27
    Hi Libby,

     

    Unfortunatily there is no way to give diretion for the date format in formula field but you can do it in a little trickty way by using this formula:

    TEXT(MONTH(Date__c))+"/" +TEXT(DAY(Date__c))+"/" +TEXT(YEAR(Date__c))

     

    You can give any format by moving the date, month and year forward and backward

     

    Let me know if this works for you or not.

     

    Regards,

     

    Gulnawaz Aamir

     

    Mirketa inc.
Antwort schreiben...
0/9000