Blog

Did you know that… You can build queries that return records that fall within a date range that you specify? Perhaps you would like to see all asset event schedules that come due within the month of January 2012?

Add the following two (2) criteria statements to your Blue Mountain RAM Query Design, to filter the ‘Due Date’ field on Asset Event Schedule Records. These two criteria statements specify the start and end dates of the desired date range.

Due Date Greater Than or Equal To ’01/01/2012′

Due Date Less Than or Equal To ’01/31/2012′

Here is how to enter these same two criteria statements in the Query Designer’s Add Criteria Window. The first criteria statement supplies the start date of the date range, and the second criteria statement supplies the end date of the date range: 

Record Type: Asset Schedules                                                                 Record Type: Asset Schedules

Field: Due Date                                                                                             Field: Due Date

Field Id: Internal ID of field                                                                          Field Id: Internal ID of field

Value Type: Normal                                                                                     Value Type: Normal

Function: Greater Than or Equal To                                                         Function: Less Than or Equal To

Value: 01/01/2012                                                                                        Value: 01/31/2012

To filter for records that fall within a date range based upon a different date field, such as work’s ‘Actual End Date’ field, or asset’s ‘Acquisition Date’, use the same criteria statements, but refer to the different date field.

For further information, consult your Blue Mountain RAM manuals. If necessary, contact us for downloads of PDFs of the manuals. Consider attending a Blue Mountain Regulatory Asset Manager Training to learn about this subject as well as many, many more! Visit coolblue.com to learn more about training and schedules.