If you need Help with Dates Check Here

Need help Database
1

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.

4 Likes
2

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

3

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

3 Likes
4

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

5

Your my hero! Works a treat. I don’t know why but I really struggle to understand dates. I wish there was some kind of course out there it would really help a lot.

Thanks very much!

1 Like
6

wonderful, thanks
!