Fetch Records within a Date Range
This seems like it should be an easy thing to do, but I can't get the syntax right. I want to fetch all the records in a form that are within a certain date range, say the last six months. I have seen syntax like this
rec = Contact [ID != 0] sort by Added_Time range from 1 to 5;
I do not understand, however, how a range for Added _Time can be an integer like 1 to 5. I would think if it as a date-time field. What am I missing? How do I get all the records in the last six months?