Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
My data is as follows
[Start Date] | [Exp End Date] |
23/02/2015 | 31/07/2015 |
07/05/2015 | 13/05/2015 |
13/03/2015 | 15/04/2015 |
07/07/2015 | 15/07/2015 |
01/06/2015 | 29/06/2015 |
01/06/2015 | 22/06/2015 |
01/07/2015 | 15/07/2015 |
I have created a list Box and wanted to pick Quarter field.
How can i do it with above information.
='Q'& Ceil(Month(date#([Start Date],'DD/MM/YYYY'))/3)
in the script you can create Quarter of start date and use in a listbox
load
[Start Date],
'Q' & ceil(month([Start Date])/3) as StartDateQuarter,
........
from
yourtable
Load startdate,
'Q'& Ceil(Month(date#([Start Date],'DD/MM/YYYY'))/3) as Quarter
this is implement at script level