Unable to Map Master calendar with Date field

[fashid]

Hi,

I am having a strange issue in mapping my calendar with QUOTE_APPROVED_DT.

I have created a master calendar to map to the QUOTE_APPROVED_DT but the calendar is not mapping correctly.

The CalendarDate is having blank values in certain rows.

I am attaching the sample app and qvd .

I would be if anybody could look into it

Regards,

Nadeem

[robert_mika]

Do you have any jobs for those missing days?

[fashid]

Hi ,

Thanks for the reply

Yes there are jobs

[mightyqlikers]

Dear Nadeem,

PFA,

$@M.

[fashid]

WHOOOAAAAA .....

That does it

Could you please explain what the issue was . It would be of great help

I do see you have used the date functions seems some problem with the date but i do not understand what was the actual issue .

Regards,

Nadeem

[mightyqlikers · Accepted solution]

date field consists of timestamp also cause of that it is making problem with master calendar.

Hope the post was correct.

$@M

[fashid]

Yes Sir Thanks a lot  . I just could not understand what the issue was and was struggling with this because i had to implement a canonical date concept .

I have also posted the same in the community .

Regards,

Nadeem Shaikh