Blog

Do you know…  Blue Mountain RAM Provides Multiple Ways of Selecting Date Ranges of Records in Queries?

Partner with Blue Mountain RAM and learn how to use date ranges for pulling your data. The following examples use the Asset Event Schedule’s “Due Date” field, but you can apply the same techniques to other fields that hold dates (Actual Start Date, Actual End Date, etc.).

Consider these possibilities for different ranges:

  1. Due Date falls within today’s date and the date that is equal to today’s date plus 31 days. This date range rolls with the change of “today’s date.”
  • Due Date Greater Than or Equal To ‘@LCLADDDATE+0@’
  • Due Date Less Than or Equal To ‘@LCLADDDATE+31@’

June1

  1. Due Date falls within a specified unchanging date range. This date range does not roll.
  • Due Date Greater Than or Equal To ‘5/1/2015’ (set Value Type to “Normal”)
  • Due Date Less Than or Equal To ‘5/31/2015’

June2

  1. Due Date falls within the current calendar month. This date range rolls with the change of “the current calendar month.”  Note: @MONTHSTART/END requires you to use the Value Type of “Normal.” See following graphic.
  • Due Date Greater Than or Equal To ‘@MONTHSTART+0@’
  • Due Date Less Than or Equal To ‘@MONTHEND+0@’

June3

  1. Due Date falls within the next calendar month. This date range rolls with the change of “the next calendar month.”
  • Due Date Greater Than or Equal To ‘@MONTHSTART+1@’  (notice the offset changes from ‘0’ to ‘1’)
  • Due Date Less Than or Equal To ‘@MONTHEND+1@’

June4

NOTE:  By specifying a date range, records without data in “Due Date” automatically are excluded from the query results. If you wish to include records without data in the Due Date field, add a criterion that “Due Date Is Empty” and join it to the other criteria with the OR join operator. See following example (criteria: date is in this range OR date is empty).

June5

For further information, consult your Blue Mountain RAM User Manual. If necessary, contact us for downloads of PDFs of the manuals. Also, please enjoy calling and speaking with your Regional Sales Manager (RSM) at (800) 982-2388 if you have questions or are interested in Blue Mountain RAM training.