issue with concatenating max(date) with date(max(date)-7)

[#1]

Hi,

with I try to show =max([Weekending Date]) in a text box, it shows 16-09-2012 . However when I try to show the following expression

='('& max([Weekending Date]) &'|'& date(max([Weekending Date])-7)&')'

It shows 09-09-2012|09-09-2012

I am out of clues why is the max weekending date starting from 7 days back. Can someone explain what is the issue here

Regards

Arif

[rajni_batra]

Hi Syed i ahve tried the same expression as urs

='('& max([Booking Date]) &'|'& date(max([Booking Date])-7)&')'

n my output is

12-09-2012|05-09-2012

perfect... i think there is some issue in ur data point,

can u post the demo so that we can resolve that.