Jump to content


Photo

Format timestamp in Update Record workflow action


  • Please log in to reply
1 reply to this topic

#1 lisaais

lisaais

    Newbie

  • Members
  • Pip
  • 7 posts

Posted 09 August 2018 - 06:02 AM

I have a text (varchar) custom field c_call, that I need to assign a string that includes the textual date taken from another custom field in the record, c_callDate, which is of type dateTime (timestamp).  This occurs in an Update Record action in a workflow.  How can I implement the conversion from timestamp to text?  In the Update Record assignment, I tried setting the Call (text) field to

date('M j, Y', {c_callDate})

but this doesn't work.  Any suggestions?

 



#2 eugeneb

eugeneb

    Advanced Member

  • Members
  • PipPipPip
  • 306 posts
  • LocationCenturion, south Africa

Posted 30 August 2018 - 08:05 AM

Is it just the date format you with to have displayed different?




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users