How Do I Calculate the Beginning of the Month of a Given Date? (Magic xpa 3.x)
It is very often the case that one needs to compute the first day of the month, especially for setting the date range for reports. There is a very quick way to do this, using the BOM() function.
The syntax of BOM() is:
BOM(date)
Where date is any date variable (or a hard-coded date, such as '05/06/2008'DATE, or an expression that evaluates to a date). It returns the first day of the month.
How Do I Calculate the End of the Month of a Given Date?
The Online and Rich Client Samples projects (program DT08 and RDT08)
