Hey, I am just trying to see how I can get this text to be dynamic with how many days are left in the month. Any suggestions?
Establish how many days there are in the current month, then deduct the current date.
i.e. there are 31 days in July, and today is 14th, so there are 17 days left in the month.
Ya that is what I thought I need to do but is there a dynamic way to determine the days in a month. Or do I need to just make a field that stores those numbers? (I feel like its the latter lol).
Outside of that, do you know how I can get this function? I just want to round the numbers like this. So 2.4M, 1.2k etc.
To establish how many days in the current month: take the current date, round it down to month, add 1 month, minus 1 Day, and extract the Date.
2 Likes
Thanks for yall help! @adamhholmes