Forum Discussion
praveenurs
6 years agoRegular Visitor
Date Hierarchy missing
I have a calendar table linked to a Calls table, i am trying to get the day-wise calls, however it doesnt seem to work! The Start Date and time field data type set to Date time As you can see belo...
- 6 years ago
I would start by spliting your "Start Date And Time" into "Start Date" and "Start Time" columns. Otherwise you will have a Date data type looking at a datetime data type.
That would be my starting position
MCornish
6 years agoResponsive Resident
I would start by spliting your "Start Date And Time" into "Start Date" and "Start Time" columns. Otherwise you will have a Date data type looking at a datetime data type.
That would be my starting position