An issue that we've been dealing with for a while now is that when using the cognos function current_date, we get a date that is two days prior to the actual current_date. For instance today is 12/15/2017. The date that would be displayed would be 12/13/2017.
Typically, we use the SQL getdate() function which is passed to the server and the correct date is given so even though this exists, it hasn't been much of an issue.
However, today I discovered that using cast( 'sometext' as date) does the same thing. While trying to track down another bug (read: feature) I used this function like this: cast('2017-11-01' as date) and stuck it in a data item. It displayed as Oct. 30, 2017.
Any idea if this is an existing known issue, or what in the world would cause this?