Bonm

Return a timestamp for midnight on the first day of a following month from a given time expression.

Syntax

Bonm(t1)

Arguments

• t1

  Time expression, enclosed in single quotes

Returns

Timestamp for the start of the next month

Exceptions

None

Notes

This function is useful for establishing a time at a unique clock time independent of the length of particular days.

Example

• Bonm('*')

  [Return a timestamp for midnight on the first day of next month]

• Bonm('y')

  [Return a timestamp for midnight on the first day of the following month from yesterday's date]

• Bonm(FindEq('att1', '-60d', '*', 50))

  [Return a timestamp for midnight on the first day of the following month when the value of 'att1' was first equal to 50 in the past 60 days]