Skip to main content
Topics#EmailFrage von ali.reza
ali.reza fragte in #Email
3. Aug. 2016, 13:57

hi team - how do i change this date 2015-08-28 00:00:00.000 to display as Aug28,2015 in SF Marketing Cloud. i need a short form with all the zeros flushed ..

3 Antworten
  1. Steve Molis (You Owe Me a Beer, Inc.)
    3. Aug. 2016, 14:05
    Is that a DateTime Field?  If it is, you could create a Formula(Text) Field with a Formula like this 

     

     

    CASE(MONTH( DATEVALUE( CreatedDate ) ), 
    1, "January", 
    2, "February", 
    3, "March", 
    4, "April", 
    5, "May", 
    6, "June", 
    7, "July", 
    8, "August", 
    9, "September", 
    10, "October", 
    11, "November", 
    12, "December", 
    NULL) +" "+
    TEXT(DAY( DATEVALUE( CreatedDate ))) +", "+ 
    TEXT(YEAR( DATEVALUE( CreatedDate )))

     

     
Antwort schreiben...
0/9000