Use like with function

[OmarBenSalem]

Hi guys, stalwar1‌

If I want to search for every field that contains the A letter I would do :

where field like '*A*'

Now what if I wanted to search for everyfield containing today() ?

How to  that since :

where field like '*Today()*' does not work ; syntax error.

thanks

[Chanty4u]

try this

is today()  is value?

where wildmatch(fieldName,'*Today()*')

or

where wildmatch(fieldName,'Today()')

[swuehl]

Can you post a screenshot of the error message?

[swuehl · Accepted solution]

If you want to replace Today() with today's date, you need to use dollar sign expansion:

Let vDate = Today(); // potential need to format using Date() to match your field values

...

LOAD

     FIELD

FROM ...

WHERE FIELD LIKE '*$(vDate)*';

edit:

Or maybe just this?

...

WHERE FIELD = Today();

[OmarBenSalem]

When I created a variable :

let vToday= today()

and then in my condition I used this variable :

where field like '*$(vToday)*' it worked.

[OmarBenSalem]

That won't work unless It's stored in a variable then we call the variable.

When I did that, It worked just fine

[OmarBenSalem]

Yes, well seen ! I just did that and I worked like a charm !