Hi all. I have an odd requirement.
I have created a number of views for a custom list I have created. I need to be able to filter these lists by what "Quarter" we are currently in (Jan-Mar - 1; Apr-Jun - 2; Jul Sep - 3; Oct-Dec -4) compared to when the item was created (i have a calculated
column that uses the created date to have the quarter). Each view is a new page (as you have created a view from within Shaarepoint)
I haven't been able to work out how to do this in the CAML query (as I can't figure out how to reference todays date in CAML).
With this out of the question, I then tried to use the Today column hack, but as this isn't dynamic, this doesn't work.