Date format 1

[Apchu (shirin sebatina)]

Hi
I want output of date in the following format (3rd may 2021).
Can anyone help me out with this please.

Thankyou !!

[sarathi125 (Parthasarathi)]

@Apchu ,

Check this xaml, I have designed with multiple IF activities, you can change it as per your need.
DateFormat_With_StNdRdTh.xaml (8.8 KB)

[flavius (Flavius Manea)]

In StudioX:

1. Format the Date in Excel and change the “Read formatting” to “Use display value”:
   
2. Use “Project Notebook”, see the “Dates” sheet as an example:
   
   
   
3. Use Advanced Editor and DateTime.Today.ToString(format):
   See details about formatting here: Custom date and time format strings | Microsoft Learn

[josephatomwanzia (Josephat Mwanzia)]

Try

Date Format to letter

Hello. You can simply format the date using “dddd” for the day of week and “MMMM” for month. Cdate("11/27/2018").ToString("dddd, MMMM d") So that takes a datetime value Cdate("11/27/2018") or if it’s already a datetime value then you don’t need the cdate(), and formats it. However, the return will not include the “th” and “st” etc In order to add the suffix to the day, you will need to use a trick I believe. Let’s just store all the suffixes into an array, like so: dateSuffixes = {"st","nd…