Forum Academy Marketplace Showcase Pricing Features

If you need Help with Dates Check Here

Hi Bubblers,

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

currentdateandtime:roundedtoday

For this week

currentdateandtime:roundedtoweek

for this year

currentdateandtime:roundedtoyear

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.

5 Likes

Hi @adunniola

Thanks for this as I really struggle with dates. But if I wanted to find out how many days are left in the current month how would I do that?

Kind regards

Hi There,

So off the top of my head, this is how i would do it. See below

Current date/time:rounded down to month +(months): 1 - Current date/time:format as days:formatted as 1029

I think this might work

Hi There,

So off the top of my head, this is how i would do it. See below

Current date/time:rounded down to month +(months): 1 - Current date/time:format as days:formatted as 1029

I think this might work