var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Between Function
Hey again -
Is it possible to use the between function with parameters but where if you enter nothing it pulls up all results?
right now it reads Between [Start Date] and [End Date], but obviously if I don't put anything as the start and end it pulls up no results.
Thanks for the help everyone! =)
I don't know for sure, but i think not.
You can use two diferent querys, and open the report with: if isnull() then... Else...
Take a look at the NZ() function.
Give this a shot in your criteria:
Between CVDate(NZ([Start Date (MM/DD/YY)],0)) And CVDate(nz([End Date (MM/DD/YY)],999999))