Bom

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

Syntax

Bom(t1)

Arguments

• t1

  A time expression

Returns

Timestamp for the start of the 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

• Bom('*')

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

• Bom(PrevEvent('att1', '*'))

  [Return a timestamp for midnight on the first day of the month when 'att1' had a value before the current one]

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

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