Linking Timestamp field to Master calendar as date

[divya_anand]

Any idea as to link the timestamp field "BDate" as a date field to the master calendar in the attached qvw?

[sunny_talwar · Accepted solution]

Try adding Floor to your mapping tables

Map_Date_Completed:

Mapping Load [CODE], Floor([COMPLETED]) Resident Data;

Map_Date_SCHEDULED:

Mapping Load [CODE], Floor([SCHEDULED]) Resident Data;

[divya_anand]

Sunny,

Thank you so much.

Just for knowledge, what if it had to be timestamp instead of date?

i.e, linking the timestamp field as a timestamp field to the master calendar instead of linking as date field.

[sunny_talwar]

I would use two tables

1) Master Calendar

2) The Master Time Table

[divya_anand]

Thank you. You've helped me a ton.