Dt

[smilingjohn]

Hi ALl

please find my QVW attached and Excel data 

I need to show a table where the release numbers should show current month releases and release number(Fututre ReleaseNUmber) greater than  than current month  .

..Release number is like 17.1, 17.2...and so on which i have converted to month year date ....

My requirement is

Display current release and all future releases

Current Release = Current date between Release Start date and End Date

Future Release = Release start date greater than current date

Can please somone suggest me how do i show it ...

Thanks in advance

[vinieme12 · Accepted solution]

Chart 1 to show current release

Current Release = Current date between Release Start date and End Date

     if(StartDate>today() and EndDate>today(),1,0)

Chart 2 to show future release

Future Release = Release start date greater than current date

     if(Release >today() ,1,0)

[pathiqvd]

I think u asked

Current Release = Current date between Release Start date and End Date,

if(StartDate<today() and EndDate>today(),1,0) maybe this is correct