cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tamer66
Resolver I
Resolver I

compare SQL DB Date Field with today

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

1 ACCEPTED SOLUTION

Accepted Solutions
v-yuxima-msft
Community Support
Community Support

Hi @Tamer66 

 

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

View solution in original post

2 REPLIES 2

Hi @Tamer66 

 

Can you try to update your expression as:
 
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!

v-yuxima-msft
Community Support
Community Support

Hi @Tamer66 

 

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

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (1,671)