Search expression with current/todays date

[Former Member]

Hi,

I have a Date field in Main table that gets updated everytime the record gets updated.

How can we write a Free Form Search Expression in SYNDICATION MAP that filters out only current/todays date modified records?

So, the date in the Expression should be dynamic. How to do that, what is the syntax?

Thank you guys.

[Former Member · Accepted solution]

Hi,

So, the date in the Expression should be dynamic. How to do that, what is the syntax?

In free form search, you can write an Expression.

Please use the below expression,

XX = LEFT(SYSTIME(0),11)

Where XX = Date Field, This expression will filter out records on the basis of current/todays date.

Kindly revert with result.

Regards,

Mandeep Saini

[Former Member]

Hi,

kindly note following step:

1. Open syndication Map

2. in free form search select update date field

3. and set Update_Date Operator : rel= value : Today 0 days

4. select map properties tab and mark(x) to suppress unchanged records fields

by keeping this setting only modified records(today/current date) will syndicate based upon record updated

Hope above mention point will resove your problem if not revert back

Thanks,

Jignesh Patel