We can customize the way that the date is represented in the "Convert DateTime to Text" Action by entering characters that represent various parts of the Date/Time along with any other characters that can be used to link the Date/Time parts. 

                                                     

Various characters and combinations can be used, some of which are displayed below. 


When displayed on their own these characters produce the following formats:

· d: The Short Date (04/02/2010)

· D: The Long Date (Friday, April 02, 2010)

· f: The Full Date Time - short Time (Friday, April 02, 2010 10:00 AM)  

· F: The Full Date Time (Friday, April 02, 2010 10:00:46 AM)  

· g: General Date Time - short Time (04/02/2010 10:00 AM)

· G: The General Date Time - long Time: (04/02/2010 10:00:46 AM)

· M: The Month and day of the month: ( April 02)

· m: The Month and day of the month: ( April 02)

· r: A Shorter Full date (Fri, 02 Apr 2010 10:00:46 GMT)

· R: A Shorter Full date (Fri, 02 Apr 2010 10:00:46 GMT)

· s: The Sortable Date Time (2010-04-02T10:00:46)

· t: The short time (10:00 AM)

· T: The Long Time (10:00:46 AM)

· y: The Month and Year: (April, 2010)



When used as a combination the characters have the following representation:

· d: The day of the month as a number from 1 to 31 (2)

· dd: The day of the month as a number from 01 to 31 (02)

· ddd: The abbreviated day of the week (Fri)

· dddd: The full day of the week (Friday)

· gg: The period era (A.D.)

· h: The hour as a number from 1 to 12 (10)

· hh: The hour as a number from 01 to 12 (10)

· HH: The hour as a number from 00 to 23 (10)

· m: The minutes as a number from 0 to 59 (0)

· mm: The minutes as a number from 00 to 59 (00)

· M: The month as a number from 1 to 12: (4)

· MM: The month as a number from 01 to 12 (04)

· MMM: The abbreviated month (Apr)

· MMMM: The month (April)

· s: The seconds as a number from 0 to 59 (46)

· ss: The seconds as a number from 00 to 59 (46)

· tt: The AM/PM designator (AM)

· y: The last digit of the year (0)

· yy: The last two digits of the year (10)

· yyyy: The year (2010)

· zz: The time zone (+02)

· zzz: The time zone in full format (+02:00)


We can mix and match these special characters in the Custom DateTime Format and add any other characters you wish to connect them. 

If you wish to use any of the characters seen in the above list as a connection character you will need to use the backslash(\) in front of it.


For example if in your custom date you need to represent the phrase 'The date is ' followed by the Date you will need to enter the following in the Custom Date field: 

T\he \da\te i\s: d/M/yy


In case the custom date has the '05/18/2018 00:11:01' representation, the Custom Date field will be:

MM/dd/yyyy hh:mm:ss