Dynamic Grouping of Dates triggered by User Input through Calendar Object
Hi all im hoping if anyone can help,
I have the following expression that gives me the field of 'T_Numbers' where my Sched_Date's fall into.
'T'& ((CEIL(CEIL((WEEKSTART(TODAY())-1) - SchedDate)/7))) AS T_Number
At the moment the expression takes todays date then minus the one which gives the date starting from a Sunday.
What I require now is for the date not to start from a Sunday anymore but it now needs to be dynamic where the date is entered through a Calendar object by a user this then takes the date and the T_Numbers should grouped accordingly.
E.g if the user enters 01/01/2013 then:
T0 - should contain 01/01/2013
02/01/2013
03/01/2013
04/01/2013
05/01/2013
06/01/2013
07/01/2013
T-1 - all the dates listed one week from the date entered etc etc
Is there a way of storing the date entered by the user from the calendar object into a variable and then using that variable to work out the T_Number field
Hope it this makes sense any help would be much appreciated
