Work with dates

There is a very common case in which you need to convert a String to a Date and Date to String. In many cases, you simply want to parse the Date in one Format and convert it to another. For example, the source data set contains a field LAST_UPDATED with a value 21Aug2019 which you need to convert to 08/21/2019.

Current Timestamp as String

com.toolsverse.utils.Utils.date2Str(new java.util.Date(), 'yyyy-MM-dd HH:mm:ss');

Convert Date/Time to String

To convert java.util.Date object to String, use function com.toolsverse.utils.Utils.date2Str(date, format).

Convert String to Date/Time

To convert String to java.util.Date object, use the function com.toolsverse.utils.str2Date(string, defaultDate, format). 

Convert Date/Time in one String Format to another

To convert Date/Time on one string Format to another, use str2Date(dateToStr(...)).

Example:

// 21Aug2019 -> 08/21/2019
Utils.date2Str(Utils.str2Date('21Aug2019', null, 'ddMMMMMyyyy'), 'MM/dd/yyyy')

Return current date in the specific time zone

To return the current date in the specific time zone, use the Calendar class:

importPackage(java.util);

var calendar = Calendar.getInstance(TimeZone.getTimeZone("EST"));

var currentDateInSpecificTimezone = calendar.get(Calendar.YEAR) + '/' 
+ calendar.get(Calendar.MONTH) + '/' + 
calendar.get(Calendar.DATE);

Available Date/Time Formats

Read more.