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:

5 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
  • Filling forms with random numbers in Katalon Studio (2)
    • Don Pedro: randomNumber is the variable that holds the result of generating a new random number. Depending on how things work on your site, you might need to convert the number to a String before it’s recognized correctly....
    • Seth: When you are setting up randomNumber is this a new keyword or a new variable? I am trying to randomly generate unique socials and can’t seem to connect my generator to my Set Text.
  • Working with Dates and Date Formatting in Katalon Studio (5)
    • Ann: THANK YOU ! That worked perfectly !
    • Don Pedro: import groovy.time.TimeCategory currentDate = new Date() println currentDate use( TimeCategory ) { after30Mins = currentDate + 30.minutes } println after30Mins https://stackoverflow.com/ques tions/21166927/incrementing...
    • ricky julianto nugroho: hay can u gave me an example for plus a hour in the time ? example : now is 15 pm i want to print 16 in the text thank you
    • Don Pedro: formattedDate=mydate.format(&# 8220;MMM”) – Nov formattedDate=mydate.format(&# 8220;MMMM”) – November
    • Ann: This was a huge help. Thank you ! Do you have something for capturing the month spelled out? and abreiveiated? Example November Nov Thanks !
  • Boostnote for Code Snippets (1)
    • Manual: Hi Don, Regarding the code snippets and examples that you have created. Is there any GitHub repo or something that can be shared? Thanks
  • Using TypeIt4Me with Katalon Studio (3)
    • Manual: That’s great thanks for sharing.
    • Don Pedro: Added a screenshot to show some examples of how I have shortcuts configured for Groovy code. TypeIt4Me supports groups, so you can create shortcuts related to Groovy, Selenium, and other topics to keep them organized. You can...
    • Manual: Hi Don, I like the idea of using the TypeIt4Me for scripting test code. Could you please share how I can create. I also like the idea of creating code templates to use with code editors. Thanks, Manual
  • Another success with Katalon Studio (2)
    • Don Pedro: Since Katalon is free, a very practical demonstration of what it can would be to create the code needed to fill in forms. That was one of my first tasks as Katalon could fill in a lengthy form in seconds versus the minute or...
  • How To Disable the Quicken Registration Prompt (18)
    • Susan Long: I have Quicken personal 2012 which I only use to enter and retrieve data. It suits my needs perfect. Now they have blocked my access and want me to re register. I don’t want to upgrade as it I am comfortable with this...
    • Stewart: I have been using Quicken 200 basic since it was introduced but I now have a new PC using windows 10 and can’t get rid of the registration prompt. I have tried the above control/shift trick but to no avail. Any ideas
  • Conditional Statements – IF .. ELSE IF in Katalon Studio (1)
    • Allyson: I used this : elementVisible=WebUI.verifyEle mentPresent… but it failed because “FAILED because (of) Unable to verify object ‘Object Repository/Homepage/b_vaolopho c’ is present (Root cause:...