How to use current date in prefilter

[sourav.mukherjee]

How to use current date in prefilter? For example if I want to filter records based on createdAt or updateAt.

[jfortun]

Hello, to use Date type field in prefilter, or any other filter you’ll have to wrap the field names in DATE()

To get current date use DATE(NOW())

For your example:
DATE(createdAt) > DATE(NOW())

For the operator you can use !=, =, >, >=, =<, <

[ilyesilno]

hello, i tried to use this syntax to compare two date and time record in a gateway step as a condition but with no success, what’s the correct syntax to use in condition fields ?

[ashevelyov]

Thanks for the answer. What all syntax does prefiltering support?
What about 7 days from now? etc.

I will dig trough the code at some point to see what it all supports - it would be a great idea to through it in the docs there for people.

Prefilter Records by Current Year, Month, Week, Day

The given code snippets are for filtering records based on different time periods – year, month, week, and day – compared to the current date. year(createdAt) = year(NOW()): Filters records created in the current year. month(createdAt) = month(NOW()): Filters records created in the current month. week(createdAt) = week(NOW()): Filters records created in the current week. day(createdAt) = day(NOW()): Filters records created on the current day. + =

[peter]

Hi @ashevelyov ,

did you check our official docs? You could use modWeek:
https://docs.cortezaproject.org/corteza-docs/2023.9/integrator-guide/expr/fnc-reference.html#_modweekdatetime_weeks

You can find the expression syntax on this page.