I recently discovered how to use the rounddownto function to manipulate dates.
For example, if you have stored your date using type date and current date and time, it can be difficult to extract the day, week or month from the date. Using the formattedas function converts the value to test and it gives you an error.
This is where the roundeddownto function really helps.
Example i want to filter by today. I use the roundeddown to function as below
For this week
for this year
This function rounds down the current date and time to the 0.00 a.m and this allows you to filter with it.
I hope this helps someone.
Im available to clarify further.