I need to filter a data table by 2 fields: one of those is a date field.
Filter('[dbo].[trackcode_AdminLogIn_and_AdminLogOut_Daily]', NSC_ID = txt_id_email_adj.Text And Admin_Logged_In >= DatePicker_LoggedIn.SelectedDate)
The date field in sql sewrver is displaying:
admin_logged_in
2021-03-16 15:26:35.370
i do not need to filter by time
Thanks
Dave
According to the documentation "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."
This is from the delegable functions and operations for SQL Server
If delegation isn't a concern then you could do this:
Filter('[dbo].[trackcode_AdminLogIn_and_AdminLogOut_Daily]', NSC_ID = txt_id_email_adj.Text And Value(Admin_Logged_In) >= Value(DatePicker_LoggedIn.SelectedDate))
Share
Report
All responses (
Answers (
6,085
