how to compare customproperty attribute with sysdate() in technical rule

[Jaya]

Hi All,

I want to create a detective technical rule through which we can compare a user's custom attribute with function sysdate()

I have used query- '(a.statuskey=1) AND (date(sysdate()) = date(a.customproperty45))' but this query isn't working. Customproperty45 is also DATE type field.

Kindly suggest solution for this.

Thanks

Jaya karothia

[sk]

What is the format you are saving date value in CP45?

[Jaya]

Hi Sk,

We have chosen attribute type as DATE in Global config for CS45.

Thanks

Jaya

[sk]

I see it is working as expected for me with below condition

(a.statuskey=1) AND (date(a.CREATEDATE)=date(sysdate()))

Can you check if you have any users with matching condition which you used?

[sk]

Jaya,

From above screenshot I see that User Form field you made a date field which you mapped to CP45 of user. But does CP45 of user table is of date type?

[Jaya]

yes i think you are correct I just checked the datatype of CP45 it's tinytext.

[rushikeshvartak · Accepted solution]

a.statuskey=1 and a.customproperty45=date_format(sysdate(),'%b %d, %Y')

[Jaya]

Thank you so much Rushikesh.