Work with dates

Overview

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 java.util.Date

var date = new java.util.Date();

Current Timestamp in milliseconds

var millis = System.currentTimeMillis();

Current Timestamp as String

com.toolsverse.util.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.util.Utils.date2Str(date, format).

Convert String to Date/Time

To convert String to java.util.Date object, use the function com.toolsverse.util.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
com.toolsverse.util.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:

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

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

Add/subtract

You can add and subtract days, minutes, seconds, milliseconds, hours, months and years to current on any date. Use negative second argument to subtract. 

Add Days

var date = com.toolsverse.util.DateUtil.addDays(new java.util.Date(), 1);

Add Hours

var date = com.toolsverse.util.DateUtil.addHours(new java.util.Date(), 1);

Add Milliseconds

var date = com.toolsverse.util.DateUtil.addMillis(new java.util.Date(), 10000);

Add Minutes

var date = com.toolsverse.util.DateUtil.addMinutes(new java.util.Date(), 30);

Add Months

var date = com.toolsverse.util.DateUtil.addMonths(new java.util.Date(), 1);

Add Seconds

var date = com.toolsverse.util.DateUtil.addSeconds(new java.util.Date(), 100);

Add Years

var date = com.toolsverse.util.DateUtil.addYears(new java.util.Date(), 1);

Available Date/Time Formats

Read more.

Available Timezone IDs