This topic is locked
[SOLVED]

 Filtering Browse

2/17/2019 8:17:18 AM
PHPRunner General questions
K
KelvinChua author

Hi Gurus,
I have the following filter that works in version 9 but not in version 10.
SELECT

"Category",

"Description",

"EventID",

"FromDate",

"FromTime",

"Image",

"Location",

"Map",

"Note",

"Price",

"Subject",

"ToDate",

"ToTime",

dayofweek

FROM "public".evevents

WHERE ("FromDate" >= current_date)

ORDER BY "FromDate"
Any idea what is my problem?
Thanks.
Kelvin Chua

SINGAPORE

K
KelvinChua author 2/17/2019

Hi Gurus,
Basically, the mentioned code is within the query.
What I require is to list only rows with "FromDate" that is >= to today's date.
Please help.
Thanks.
Kelvin Chua

SINGAPORE

K
KelvinChua author 2/17/2019

Hi All,
Please consider issue resolved.
Someone had accidentally change the web server system year to 2001. They had fixed and notified me.
Thanks.
Kelvin Chua

SINGAPORE