Date
      Back to home
      1. Help Center
      2. Operations
      3. Date

      DATE_FORMAT Operation

      How to use the DATE_FORMAT operation in formulas

      Definition

      Example

      Syntax Guide

      Definition

      The DATE_FORMAT operation allows you to change the date format using the following tokens:

      Configuring Date

      Example

      $ATT.DATE = 2020-03-22

      DATE_FORMAT($ATT.DATE, ‘%d-%b-%Y’)

      Result:
      22-Mar-2020

      Syntax Guide

      DATE_FORMAT(date, format)

      date - the date to be formatted

      format - the new format of the date

      DATE_FORMAT Operation

      What's Next

      Check out similar operations like: 

       

      If you have any questions just click on the chat box in the bottom-right corner and we'll be happy to answer them...

       

      and please let us know 👇