topic Re: how to Local data filter with today's date in Discussions

how to Local data filter with today's date

wendong — Thu, 27 Feb 2020 19:02:56 GMT

We are trying to filter the date by today's date.

original line of code is Where( :DateOnly == "2020/02/27" ),

I try to replace the date by Short Date(Today()) or "Short Date(Today())", "|| Short Date(Today())||' ; nothing worked, anyone can help?

----------

Local Data Filter(
Width( 178 ),
Add Filter(
columns( :DateOnly, :Equipment ),
Where( :DateOnly == "||Short Date(Today())||" ),
Display(
:DateOnly,
Size( 172, 238 ),
Height( 238 )
),
Display(
:Equipment,
Size( 172, 51 ),
Height( 51 ),
"List Display"
)
)
),

Re: how to Local data filter with today's date

txnelson — Thu, 27 Feb 2020 19:17:54 GMT

Apparently your :DateOnly column is of data type character.
The function Short Date() returns the format of "mm/dd/yyyy" and you need "yyyy/mm/dd"
The format "y/m/d" will return that value and if you use the Format() function it will return it as the character string you desire

Where( :DateOnly == format(today(),"y/m/d") );

Re: how to Local data filter with today's date

wendong — Thu, 27 Feb 2020 19:56:30 GMT

Thanks Jim for saving my day. ( I just need to change your line of code at the end from the semi colon to comma, then it works out)

Where( :DateOnly == format(today(),"y/m/d") ),