Date prompt returning zero vales

[barrysaab]

My report is a list report which has date prompt "Start Date" and it doesn't have end date Now the end user wants to view data from Ist Aug to 18 Aug. I have changed the date prompt to in-range but the report is returning zero values.

Please help.Thanks

[bvk.cognoise]

HI barrysaab,

first check whether in DB it has records between Ist Aug to 18 Aug or not, second one please check the format of  Date in  your column.whether it only contains Date  or Date and time.if it contains date and time please try to convert it into date then try it once again.

thanks
bvk

[barrysaab]

It has values for particular dates,the report is working fine when i choose particular startdate but as i have changed and added "End Date" and changed the filter also,and this is giving zero values.Thanks

[MFGF]

Hi,

Silly question - did you change the date filter to in_range, or did you change the date prompt 'Range' property to be 'Yes', or both?  You will need to have done both for it to work as you expect.

Regards,

MF.

[barrysaab]

Thanks,i did the both.But it still behaving the same way.

[MFGF]

Can you show us the expression you are using in your filter?

[barrysaab]

I have applied these filters.

[Sales DM].[DATE].[Calendar Date]<=?End Date?
[Sales DM].[DATE].[Calendar Date] >= ?Start Date?
[Sales DM].[DATE].[Calendar Date] between ?Start Date? and ?End Date?

But I suspect the data is not coming correct, secondly when I changed the Calendar Date]>=?End Date? and [Sales DM].[DATE].[Calendar Date] <= ?Start Date? it is returning zero values. Could you guys please help? Thanks.

[MFGF]

Ah! I see the problem! Remove the first two filters and just leave the third in place - all you need is a single filter with the expression

[Sales DM].[DATE].[Calendar Date] between ?Start Date? and ?End Date?

Regards,

MF.