Set Analysis Date Range

[jlampard40]

Hi All - I have the current set analysis:

=Count({<[HR Next Appraisal Date] = {'>=$(=Date(Today(1)+3<=$(=Date(Today(1) + 10))'}>} [HR Assignment Number])

I'm trying to get it to show me all records where employee appraisals are due, between 3 days and 10 days from today's date.  The above is pulling records much older than today's date (a year ago!) so bit confused!!!  Can you help?  Many thanks.

[jlampard40]

Great - the chr(10) doesn't seem to want to work though Sunny.  Still getting the names in one line.  Any ideas?  Rgds

[sunny_talwar]

Try Chr(13)

[jlampard40]

No - still no luck Sunny.

[sunny_talwar]

Where exactly are you using this? In a text box object? Would you be able to share an image of the text box object? What delimiter does it show when you use Chr(10) or Chr(13)?