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)
}
This was a huge help. Thank you !
Do you have something for capturing the month spelled out? and abreiveiated?
Example
November
Nov
Thanks !
formattedDate=mydate.format(“MMM”) – Nov
formattedDate=mydate.format(“MMMM”) – November
THANK YOU ! That worked perfectly !
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
import groovy.time.TimeCategory
currentDate = new Date()
println currentDate
use( TimeCategory ) {
after30Mins = currentDate + 30.minutes
}
println after30Mins
https://stackoverflow.com/questions/21166927/incrementing-date-object-by-hours-minutes-in-groovy
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)
formattedDate = mydate.format(“M/dd/yyy”)
I want to choose date from any of the 12 months but I am not abel to do the same.
Not sure I understand what you are trying to do.
Useful !
today = new Date()
lastWeek = (today – 1.week)
can u please help me in understanding what is the return type of lastweek?
and I wanted to set nextyear date how can i do it
It should be of the same Date type as today.
You could then do some calendar trickery with Calendar
/*Calendar c = Calendar.getInstance();
//c.set(Calendar.MONTH, 1) //Set the month, 0=January, 11=December
println c.getActualMaximum(Calendar.DAY_OF_MONTH)
println c.getActualMaximum(Calendar.WEEK_OF_MONTH)*/
I’m testing a page with a string like “Updated November 21, 2019 16:25:32 PM Central Standard Time.”
How might I capture the date and time and compare it to current time to verify that the update time was within the last 60 minutes?
That could be a little tricky. First, is the text/format always going to be the same?
You will need to do some parsing. Separate the first but of text at 2019.
After that, split the text again to get rid of Central Standard Time.
You will then have to convert the 16:25:32 into an actual time with .format()
From there you should have a usable date
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.