How to Convert a Date/Time to Text

Question

I want to include a time stamp in a comment text field using a formula. I used the TEXT(Now()) which did the job of formatting the date just fine except the time stamp seems to be in a different time zone to mine. How can the Now() return the right time ?

it was 11h15 my time and I got this time stamp: 2015-04-02 03:15:03Z.

Also, as a side question... how can i add a carriage return in a text field using a formula"?

Varun Pilla · Accepted Answer

Helene, I guess it is because the NOW() function always returns the date value in GMT. One simple thing to do would be add a "GMT" suffix to your text. If that is not a suitable alternative, here is an elaborate formula to convert a Date/Time value to another timezone: https://help.salesforce.com/HTViewSolution?id=000181642

By the way, if you are annoyed with the "Z" (which stands for zone) that gets appended at the end... You could trim that out with the LEFT () function.

LEFT( 
      TEXT( NOW() ), 
      LEN ( TEXT ( NOW() ) ) -1 
    )  
+ " GMT"

As for the carriage return, try the BR() function. It inserts a line break in a string of text.

Julie Pearson · Answer

Even though it is many years later, it might help someone that this link will take you to the current documentation.  (as of April 2022) as the link above no longer works https://developer.salesforce.com/docs/atlas.en-us.216.0.formula_date_time_tipsheet.meta/formula_date_time_tipsheet/formula_using_date_datetime.htm

How to Convert a Date/Time to Text

Data Management

관련 학습

도움 더 받기