Filtering data from 01/07/2015 to 01/04/2016 in list box

[Anonymous]

Hi All,

I created master calendar from 2013 to 2016.

I need a list box (column name is Month) from july 2015 to April 2016.

(01/07/2015 to 01/04/2016)

  Sample data:  

CDate	Fiscal Quarter	Month
04/01/2013	Q1	April
05/01/2013	Q1	May
06/01/2013	Q1	June
07/01/2013	Q2	July
08/01/2013	Q2	Aug
09/01/2013	Q2	Sept
10/01/2013	Q3	Oct
11/01/2013	Q3	Nov
12/01/2013	Q3	Dec
02/01/2014	Q4	Feb
03/01/2014	Q4	Mar
04/01/2014	Q1	April
05/01/2014	Q1	May
06/01/2014	Q1	June
07/01/2014	Q2	July
08/01/2014	Q2	Aug
09/01/2014	Q2	Sept
10/01/2014	Q3	Oct
11/01/2014	Q3	Nov
12/01/2014	Q3	Dec
01/01/2015	Q4	Jan
02/01/2015	Q4	Feb
03/01/2015	Q4	Mar
04/01/2015	Q1	April

Thanks,

Krishna

[Chanty4u]

May be chk dis

Selecting Arbitrary Date Ranges

[avinashelite]

Try like this:

If(CDate>=''01/07/2015' and CDate<=' 01/04/2016',CDate)

or

you could push the values into variables and then you can use the same

vStart=01/07/2015

vEnd=01/04/2016

If(CDate>=vStart and CDate<=vEnd,CDate)

[Anonymous]

Hi ,

Comm:

LOAD CDate,

     [Fiscal Quarter],

     Month,

     Month(CDate)&Year(CDate) as NewMonth

FROM

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq)

Where Date(CDate)>='01/07/2015' and Date(CDate)<='01/04/2016';

[ankit777]

Hi

you want a list box showing dates from  july 2015 to April 2016.(01/07/2015 to 01/04/2016)

or

you want to select these date range by clicking on some button?

[Anonymous]

Hi,

  I"m looking filter data in list box by range of dates.

I need Empid in a list box from 01/07/2015 to today  only,

Empid in a list box from 01/01/2013 to 01/07/2015  only

and Month in a list box from 01/07/2015 to today only.

Thanks,

Krishna

[kkkumar82 · Accepted solution]

Create a list in the list box and goto the "expression" option which you can see last in the fields.

Write the expression as

I need Empid in a list box from 01/07/2015 to today  only

     if(datefield>=date(date#('01/07/2015','DD/MM/YYYY')) and datefield<=today(), EMPID)

Empid in a list box from 01/01/2013 to 01/07/2015  only

  if(datefield>=date(date#('01/01/2013','DD/MM/YYYY')) and datefield<=date(date#('01/07/2015','DD/MM/YYYY')), EMPID)

Month in a list box from 01/07/2015 to today only

if(datefield>=date(date#('01/07/2015','DD/MM/YYYY')) and datefield<=today(), Month)

Hope it helps

[ankit777]

Hi

Try using calculated fields then

Make a new list box and add expression to it:

1)

=if(CDate>'01/07/2015' and CDate<today(),Empid)

2)

=if(CDate>'01/01/2013' and CDate<'01/07/2015',Empid)

3)

=if(CDate>'01/07/2015' and CDate<today(),month(CDate))

[avinashelite]

try with the If condition

If(CDate>=''01/07/2015' and CDate<=' 01/04/2016',required_field)

[kkkumar82]

Can you also update ur data by adding EMPID so that I would be perfect for giving a sample for you