I wanted to upload my workbook but I don't know how to remove the data. I've tried unpacking it but the data is still there. Also, I'm not able to see the videos from this forum about sharing workbook because in my company is not allowed.
You can use today() to make it relative.
if [Filter on/off]=false
(month([Date])= month(dateadd('month',-1,today()) )
Instead to set date parameter, I added filter "on/off" parameter.
date_filter2.twbx 7.1 KB
sorry for the late reply.
thanks you for your answer, I think this could work. (I guess I can use relative dates into the parameters).
just a quick question please: what means the ,<14 ? I couldn't find this element in the DATEDIFF syntax.
thank you again.
2 of 2 people found this helpful
1 day (24 hours ) = 1
Then, 14 means 2 weeks.
1 week = 7
1 hour = 1/24
1 minute = 1/(24*60)
1 second = 1/(24*60*60)
1 month = NG
1 year = NG (Typically 365, but 366 every 4 years except every 1000 years )
with days would have been enough info but thanks for your answer.
You are welcome.