Forum Discussion
rushikesh_27
4 years agoFrequent Visitor
Userelationship function giving blank results.
Hello all, I'm trying to use the userelationship function for a model. I have 3 tables. Calendar, Shipment, Sites Where Calendar(date)is connected to 2 dates of Shipment( early_ship date-active, l...
amitchandak
4 years agoSuper User
rushikesh_27 , Make sure date table have all the dates.
Makse sure that Loddte only date have no time stamp - Change data type to datetime and select format with time. Time stamp should be 00:00 or 12:00.
if that is anything other than that then create a date column
Loddte only date = datevalue([Loddte only])
join date with that and use
rushikesh_27
4 years agoFrequent Visitor
Thank you for the support.
Made sure that the date does not have any time stamp. The Calendar date is having all he dates as well.
Still shows blank values.