Get a date and time

There are functions which you can use in your rules to get a particular date and time.

What do you want to do?

Get the current date and time

Get a date and time by joining together a separate date and time

Get a date and time from another date and time

Get the current date and time

To insert the system date and time into a rule, you use the Current Date Time function. For example, the following comparison:

the date and time of the investigation = CurrentDateTime()

will infer the date and time of the investigation to be 2007-11-12 15:37:00 if the rule is run on 2007-11-12 at 15:37:00.

NOTE: The Current Date Time function returns the system date/time at the start of the session.

Get a date and time by joining together a separate date and time

To set a date and time from a separate date and a separate time, you use the Concatenate Date Time function. For example:

the latest submission time = ConcatenateDateTime(the submission date, the submission closing time)

will infer the latest submission time to be 2010-01-15 17:00:00 if the submission date is 2010-01-15 and the submission closing time is 17:00:00.

Get a date and time from another date and time

To set the value of a date and time variable from another date and time, you use the DateTime function. For example:

the latest submission date and time= DateTime(the submission date and time specified on the application form)

will infer the latest submission date and time to be 2012-12-31 18:00:00 if the submission date and time specified on the application form is 2012-12-31 18:00:00.

 

See also: