Test Data Manager

  • Private Community
Back to discussions
Expand all | Collapse all

How to generate Date in required format

  • 1.  How to generate Date in required format

    Posted Jul 15, 2017 12:32 AM

    Hi,

     

    I want to generate the date in the below format.

    Date: 15th July and 15th July 2017

    If i use STRING(DATE, DATEFORMAT), i am not able to generate the desired format.

     

    Could you please let me know how to to generate the date in the above format.

     

    Thank You.



  • 2.  Re: How to generate Date in required format
    Best Answer

    Posted Jul 17, 2017 12:40 PM

    Timestamp filter with format dd'th' MMMM and dd'th' MMMM YYYY



  • 3.  Re: How to generate Date in required format

    Posted Jul 19, 2017 05:43 AM

    Thank You for the update.