Show only date

[prasadreddy]

Hi All,

I have the Date field with values

                       2013-02

                       2013-03

                       2013-04

But, i want to display only '2013-04 onwards', before the 2013-04 dont want show,

i have to show this list box in dashboard level,

any one help on this appriciate

Thanx

[tresB]

Select expression in the 'field' drop down under general tab of list box and write the expression like:

If( DateField >= '2013-04', DateField)

This should work if your date filed is in proper date format.

[narender123]

in list box

General>field>expression

write

if(datefileld='2013-04','2013-04','2013-04')

NOw list box only show 2013-04

or if you want date>=2013-04

if(datefileld >='2013-04',datefileld)

Thanks

Narender

[prasadreddy]

Hi Tres,

I tried this, but it is showing all values in decending order

[narender123]

In sort select datefield as ascending

[tresB]

must be format issue, try this:

If( date#(DateField,'YYYY-MM')>= '2013-04', DateField)

[prasadreddy]

Hi Tres,

Its working

Thank you