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:

6 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
  • How to Block games by Title and Tag on Steam (1)
    • JACK: Thanks, same just wanted to block anime games in my discover
  • How To Disable the Quicken Registration Prompt (25)
    • Greg: For me, holding the *LEFT* CTL + Shift then clicking Online, One Step Update worked. I originally tried holding the right CTL + Shift, and it didn’t work. I’m using Quicken 2006, so I don’t know if it will work...
    • Joe SR>: My monthly income is deposited into my Credit Union account. I use debit whenever possible. I write checks manually and mail them. I use Quicken 2012 off-line only. I have entered all my money and investment accounts. I...
    • Prtet: Never say never….every time I swear I will never use Quicken again, I discover that there are still no viable alternatives. Amazing that there is no decent personal finance software.
    • Joe D.: Holding CTRL + Shift keys and selecting On Line | One Step Update from the main menu worked for my Quicken 2004. I’m grateful that you wrote a synopsis (“Simply put, …”) just beneath the link to the blog...
    • Susan Long: I bought my quicken disc in the beginning and it came with a registration number. I rang the helpline and they gave me the code to put in and talked me through it. It you downloaded your version then you don’t own it...
    • Peter: You might consider running your old version of Quicken on an ancient computer. This is what I have done for years. The newer versions are fraught with problems- criminal, in my opinion. One version made mathmatical errors when...
    • Roslyn Chamberlain: Can I stop the countdown in quicken 2001 says only 8 sessions left. and what will happen after?
  • Parsing Strings in Katalon – Split, Substring and Readlines (1)
    • Ellen: Thanks for sharing!! I like your contributions to Katalon topics.
  • Working with Dates and Date Formatting in Katalon Studio (6)
    • Ajoo: Thank you for the details. How do i remove leading “0” from dates. i.e. while formatting i receive 04/21/2019, but i need 4/21/2019. (same applies for date)
  • What is Katalon Studio? A Distro of Selenium, Groovy and Eclipse (1)
    • Mahesh: Looking for more posts on katalon studio.your katalon stuffs are always exiting
  • Simple wildcard searches for pattern matching (2)
    • Don Pedro: For that scenario it seems .contains would be your choice. For example, variable.contains(‘amazo n.com’) to see if the url had amazon.com. In that case, www.amazon.com, forum.amazon.com, retail.amazon.com would all...
    • Jony: Hi, How can I use a wild card to assert a URL is the one I want. I just want to verify the domain ==expected but not anything after it. Tried * but not working and only works when I have full URL.
  • Create a Dynamic Object at Runtime (2)
    • Saish: How to add shadow root parent to this runtime object..
    • Jeremy Brien: I appreciate this! I saw this post on LinkedIn this morning and was able to find a use case for it! I found that defining my xpath with an iterable variable allows me to loop through and capture text from tables created...