I agree. The answer is wrong according to the given explanation.

SSC

After some research, I've found the issue. PeopleSoft automatically creates some views with queries with Database Manager System compatibility (those are supposed to run...

Thanks.

As I thought, this is a datetime format issue. My PeopleSoft team says that {fn CURDATE()} is the only way they can perform querys, so they...