Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
Hi Tres,
I tried this, but it is showing all values in decending order
In sort select datefield as ascending
must be format issue, try this:
If( date#(DateField,'YYYY-MM')>= '2013-04', DateField)
Hi Tres,
Its working
Thank you