compare SQL DB Date Field with today

[Tamer66]

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

[yashag2255]

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 · Accepted solution]

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