Has date logic in reports changed

[Keith]

Hi, 

I have had reports from a colleague that their previous dashboard is no longer working as expected. Has anything changed?

 

 

For a 7 day period we previously used e.g. : 

h_dateresolved >= current_date-7 AND h_fk_team_name='LMS IT NA Service and Support'

 

This does not work anymore.  We now need to use : 

h_dateresolved >= DATE_SUB(current_date, INTERVAL 7 DAY) AND h_fk_team_name='LMS IT NA Service and Support'

 

Regards

 

Keith

[Victor]

@Keith firstly apologies for the very, very, very delayed reply  ... I am not sure how this was missed

 

About this:

On 05/12/2017 at 4:17 PM, Keith said:

h_dateresolved >= current_date-7

.. this is a valid expression, I am not entirely sure why you say is not working anymore. If this is still an issue can you give me some more details, please?