Announcements
Hello,
i have a Aure SQL DB with a Date Field und would compare it with the current today to get all record
only from today.
My Formular:
Filter('[dbo].[SQL_DB]';Today() = dateTable And
MemberNumber = "007")
This gives me 0 records back
Has anyone an idea?
Thanks
Hi @Tamer66
Filter( '[dbo].[SQL_DB]'; DateValue(Text(dateTable)) = Today() && MemberNumber = "007" )
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Could you please test with @yashag2255 's suggestion?
And you can also change the formula expression as this:
Filter('[dbo].[SQL_DB]';Text(Today())= Text(dateTable) And
MemberNumber = 007)
Best Regards.
Yumia
Hi I have used this formula and it worked. But getting the delegation warning how to avoid that warning ?
DateValue(Text(ThisRecord.AssignedTo_UpdatedDate)) < Today() )})
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 483
WarrenBelz 399 Most Valuable Professional
11manish 327
