Current Date in Flexible Search

[former_member586063]

Hello,

Is there a way that I can use the current date in a flexible search query? I am using pre-fixed values. But I want to make my query more generic, so that I can use it, on another day, without changing anything.

My Hybris is 6.1.0.18.

Thanks!!

[former_member586063 · Accepted solution]

I got it with a friend, here. I can use current_timestamp to get the current date! Without braces, quotes, etc. So, in my query, it would be " AND {enddate} <= current_timestamp "