Thanks for you reply.
what about if we having the null dates and will you please calculate the difference in between the
required date and today's date
i have a doubt
where calculation= orderdate > parameter1 and orderdate < parameter2
orderdate is from another data source
but the above if condition is not valid can you please help me how to resolve
Hmmm...when things come from a different datasource it's hard to interpret your scenario from a distance.
Can you share a workbook?