Working with Dates and Date Formatting in Katalon Studio

Working with dates in Groovy is actually quite easy, once you understand the proper formatting. For my tests, I use the date to check when an import was run. Another use is to append the date to company names, prospect names and task subjects so I know when they were created and give each entry a slight bit of uniqueness.

To start, a variable needs to be set to the Date.

mydate = new Date() – Returns a full string of – Sun Jan 28 11:45:13 EST 2018

Once the date has been calculated from the system, it’s time to parse it into it’s competent pieces. The formatting looks similar to those used in spreadsheets.

Here are some examples and the returned results.

formattedDate = mydate.format(“MM/dd/yyyy”) – month, day, year

01/28/2018

formattedDate = mydate.format(“dd”) – Day

28

formattedDate = mydate.format(“MM”) – Month

01

formattedDate = mydate.format(“yyyy”) – Year

2018

formattedDate = mydate.format(“EEEE”) – Day as Text

Sunday

//Shows whether it is AM or PM

formattedDate = mydate.format(“a”)

AM

//Adds AM or PM to the end of the time

dateHour=mydate.format(“hh:mm:ss a”)

11:52:23 AM

dateHour=mydate.format(“HH:mm:ss”)

11:52:23

As noted, the date can be used at the end of names to make them unique. The following lines are used to get the current date and time, then append to the company name so it’s not the same name over and over again.

Note the / and : are separators and can be left out to form complete numbers.

//The date is appended to the name of the company to create randomness and show when the Prospect was created

mydate = new Date()

formattedDate = mydate.format(“MMddyyy”)

dateHour=mydate.format(“HHmmss”)

WebUI.setText(findTestObject(‘Page_/Prospect Page Objects/New Prospect Fields/Prospect-Company Name’), ‘Amazing New Company ‘ + formattedDate + dateHour)

This creates an entry with the text:

Amazing New Company – 01162018162000

The Date command can also be used in calculations. For example, you can get the date for today and determine the date for yesterday, or three days ago. The code below is used to check when the last import was run based on today’s date.

It first gets today’s date – today = new Date()

That is then used to calculate yesterday’s date – yesterday = today.previous()

If today is “Monday” the report should have run on “Friday” – 3 days ago (today -3)

— Going back three days without having to use calculations —

today = new Date()

yesterday = today.previous()

todayDate = today.format(‘MM/dd/yyyy’)

reportDate = yesterday.format(‘MM/dd/yyyy’)

dayOfWeek = today.format(‘EEEE’)

if (dayOfWeek == ‘Monday’) {

    yesterday = (today – 3)

    print(‘Yesterday is:’ + yesterday)

    reportDate = yesterday.format(‘MM/dd/yyyy’)

    println(‘The new import date is:’ + reportDate)

}

Other articles of interest:

15 Responses to Working with Dates and Date Formatting in Katalon Studio

Leave a Reply

Your email address will not be published. Required fields are marked *

Recent Comments
  • Signing up for the Katalon Webinars (1)
    • Nagesh: Thank You . I found alot of new concepts
  • How To Disable the Quicken Registration Prompt (32)
    • Mike: Hi, for anyone still trying to run older versions of Quicken, mine is 2004, I hope this helps. I managed to get it running on my old laptop by adding the three missing dll files, when I needed to upgrade I thought I would be able...
    • Juani: Hi, I have a registered Quicken 2016 and now my files are being held hostage by Intuit, cannot log in with my ID unless I upgrade therefore buy a subscription, I need to access my files, please HELP. Thanks
    • David: A BIG Thank you! I regularly reinstall Windows OS’s using different hardware configs. In short, Quicken 2011 (it’s March of 2020 as I write this) has been a program I’ve been very happy with and continue to use....
    • Karen L: Today I rang Reckon Australia again, got a different guy and he talked me through the process of getting me a new product key to enter since I already had the licence and it had been extended. Reckon have only extended it by 1...
    • Karen L: I have Australian Quicken 2008 on Windows 8.1. It keeps asking me to renew my licence which Reckon did for me however the activation won’t work. I tried this to disable the registration prompt however it did not stop the...
  • Enter dates into a date picker for Chrome and Firefox (1)
    • Prasanna: Hello, How to enter a previous month FIRST day and LAST day from the system date. Thanks Prasanna
  • Building Relationships with Developers (1)
    • Carlos Herrera: Ah yes. I have a team of software developers and it is genuinely so hard to keep them in the loop during projects. Though the more we work the better the communication becomes and we go from a trail and error process to a...
  • Integrating DevonAgent Pro with Alfred (1)
    • J. Garr: Beautiful, sweet, and simple. I love it; thanks for posting this solution.
  • Round and Round with the For..Next in Katalon Studio (1)
    • Sweet Ophaline Labador: Hello can you help me how to loop this scenario. Checking the elements is just the same. I want to check that the following function is available in www.siacargo.com: Track Shipment – clicking on this can...
  • Parsing Strings in Katalon – Split, Substring and Readlines (6)
    • Don Pedro: String tempText=”Date Month January. Revenue $1,355,721.00″ println(tempText.split(“ \$”)[1]) You need to escape the $ with \$ The [1] on the split captures characters on the right of the split [0]...
    • Prasad: Hi, I need to get the substring from the below string ‘Date Month January. Revenue $1,355,721.00’ I want to extract text after $ value. Please help Thank you
  • Working with Dates and Date Formatting in Katalon Studio (15)
    • Sangeethaa: How to get previous day’s date(Yesterday’s date)? Actually I was using today.previous() before,it was working fine till today morning.Now its not retrieving right date. Can anyone please guide me on this.
  • Output status messages and test information by writing to the Log File Viewer in Katalon Studio (6)
    • Saranya: Good One. Could you plz share link to access all your katalon related blogs. ThankQ
    • Rodrigo Calabretta: I’m using the KeywordUtil.markFailed or KeywordUtil.markError and my test stops is being shown as Error and If I use in the @afterTestCase the testCaseContext.getTestCaseSta tus() to show the status test case...