Calender Posting Date Problem

[vikasmahajan]

Dear all,

Please Find attachement of  t.qvw which contains last day of june date with master calender this gives me max(postingdate) as 30/06/2014  date , But while I apply same logic in production environment  this shows me date 1/07/2014 , does any body suffer from such issues I attached script also for live.

Vikas

[rwunderlich]

In the script you posted,

max([Posting Date]) is defined by the SQL statement:

SQL SELECT MaxDate

FROM "QLIKVIEW_SIM_DB".dbo.MAXDT;

Is 1/7/2014 what is returned in production?

-Rob

[vikasmahajan]

Rob Sir,

It Returns 30/06/2014  end of the month . But when I  implement the same in live with link tables it takes max(postingdata) 01/07/2014 date.

Thanks

Vikas

[vikasmahajan]

Sir,

I found there are collections entry passed in 01/07/2014 date and I thing via Link table max(posting date) might be a 1/7/2014.

Vikas