AFTER MANY YEARS PERFECT JOB and now
DO NOT WORK - Filter('[dbo].[ObedListek]';Datum>Today()) - now return empty collection - Datum is Date field in SQL table
I must change to Filter('[dbo].[ObedListek]';DateDiff(Datum;Today())<=0)) - this work fine
Next new problem
DO NOT WORK - OnSelect on any inserted element (text,button,..) in DataCard in FormViewer (pointer changed on hand, but not fired Launch("..")) on the same screen Button out of FormViewer work fine.
Hi @barta ,
Q1:
The reason why you met this problem is that:
Direct date filters do not work for SQL Server.
However, you can create a calculated column that will work. For instance, ALTER TABLE myTable ADD DateAsInt AS (YEAR([date]) * 10000 + MONTH([date]) * 100 + DAY([date])) and then filter on the calculated number column.
For example:
Share
Report
All responses (
Answers (
Filter(AddColumns('[dbo].[ObedListek]';
"newdate";
YEAR(Datum) * 10000 + MONTH(Datum) * 100 + DAY(Datum)
);
newdate>Value(ToDay())
)Here's a doc about SQL Server connector for your reference:
https://docs.microsoft.com/en-us/connectors/sql/
Q2:
The reason why you met this problem is that you put the button inside the formviewer.
Since the formviewer's mode is View, the button's mode will change with it automatically.
So I suggest you put the button outside the form.😀
Best regards,
#1
WarrenBelz
146,702
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,015
Most Valuable Professional
