ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Rally WSAPI query with the (date_field > today-n) returns unexpected data


Article ID: 237550


Updated On:


CA Agile Central SaaS (Rally) CA Agile Central On Premise (Rally) Rally Perpetual Hosted


When using a query such as (date_field > today-n) no data is returned or unexpected results are received.


Using the greater than operator with the today expression changes how the comparison is performed in the database.  Instead of creating a date range expression that starts as today's date minus n days, it treats it as simply today's date so it looks forward into the future starting at today's date.


Use (some_field >= today-n) which will look back n days from today and into the future.