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

Tue, 18 Sep 2012 08:18:51 GMT

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

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

rajni_batra — Tue, 18 Sep 2012 08:27:37 GMT

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.