I am trying to create view that shows the number of PO receipts per day. The process owner has requested to see days where no receipts were performed in the data. Since there is no data for those days, it is not represented. I tried pulling in the ZCALENDAR to join to PRECEIPTS but cannot make the join because the data types are different (DATE vs DATETIME). In SQL, I would convert the data in order to make the join but it doesn't seem like this is possible in SEI because the join has to occur before the data is manipulated. I am considering creating a view in X3 to convert the date then joining on that view but it seems like I may be missing something in SEI.

Does anyone have any suggestions?