Data Blaze Filter By Month

How to read data on snippets from a table with the condition that the date is this month?

Hi @Kronik_Grooming,

Welcome to the forum :slightly_smiling_face:

You can use our datetimeformat function in BSQL to extract the month from the Date column and provide conditions on that. Here is an example of the same.

1 Like

Screenshot 2023-10-14 163314
Thank you for your help,
next how to determine the month to be dynamic
according to the current month without changing the code every month

You can use the now() function to do that. In this example, your query will become SELECT Name, `Joining Date` FROM Dates WHERE datetimeformat(`Joining Date`, "MM") = datetimeformat(now(), "MM").