Error on "bigger then" date

Error on "bigger then" date

  

I'm trying to build an aggregate showing all records from last week.
So I'm trying this filter:

 Code Snippet

Application.CreatedOn > "2017-11-04"

This however gives me an error:
Operator > cannot be applied to operands of type Date Time and Text.

Anyone know what's going on, and how can I user > and < on date time records?

Solution

Hello Paul,

I think you have 2 problems there, and none are the ">" :)

To use a "literal" date / date time value, you use the # around it, not "
Also, if CreatedOn is a DateTime, your literal must be complete.

Like this:

Application.CreatedOn > #2017-11-04 00:00:00#

At least on the last version of Service Studio.

Cheers,
Eduardo Jauch

Solution

Thank you very much. That solved it