Date n(h/min/sec) after the specified date

1.Overview

1.1 Problem description

Date function is widely used in daily work and life. It is particularly important to add or subtract the specified time interval from the date.

At present, the use of some date functions is provided. See date function for more details.

However, sometimes it is necessary to obtain "the date of n (hours / minutes / seconds) after the specified date". How to deal with it?

1.2 Implementation ideas

Combine function TODATE and DATETONUMBER to calculate.

2.1 Add new fields

Create a self-service dataset. Take the current time now() = 「2021-07-27 14:11:16」" as an example, and use "add field" to obtain the date values after 2 hours, 2 minutes and 2 seconds respectively. The formula is shown in the following figure:

Similarly: add the field "after 2 hours, after 2 minutes, after 2 seconds", and the formulas are as follows:

Formula interpretation:

Note: the fields in the formula need to be selected from the field box on the left and cannot be entered manually.

2.2 View the effect

Save the self-service dataset, the effect is as shown in the following figure: