User Profile

BobF

Data Storage

Joined 5 years ago

2 Posts1 Solution

View All Badges

User Widgets

Contributions

Re: Year-To-Date for Only Completed Months
Hello I would suggest adding a new custom column called, say, "YTD", set to "Y" or "N" based on whether the date/timestamp column you are using is the same year as today but not the same month as today Regards, Bob
04-05-2022 Place Build Analytics
3KViews
0likes
0Comments
Re: Advanced Date Filter - Allow User to Select Different Dates
Hi I've done something similar, adding a new custom field e.g. "Monthly_Report_Date", based on the date, using a Case statement to build it up. You can add as many values you want. Below shows an example for just 3 values Case WHEN MonthDiff(CURRENTDATE(),[<Your_Date>])=0 THEN 'Current Month' WHEN MonthDiff(CURRENTDATE(),[<Your_Date>])=1 THEN 'Last Month' WHEN MonthDiff(CURRENTDATE(),[<Your_Date>])=2 THEN 'Two Months Ago' END
02-28-2022 Place Build Analytics
2.1KViews
0likes
0Comments