SLICE CUSTOMER Table based on the follow up date in child table

[Aditya_Vinayak_]

Currently I have 3 Tables:

1) Customer Database        2) Call Logs      3) Services

I am trying to create a slice of my customer database table based on the follow up date being today in the call log table.

I have used the below expression

IN(TODAY(),[Related Call Logs][Follow Up Date])

Since the follow up date is in DATETIME format, I am getting values which only have the follow up date as today & time as 12:00 AM.

I am aware that for the system to assume the follow up date as date format, I have to use the following formula, DATE([Follow Up Date])= TODAY().

But how do I incorporate it in my above formula

Do help me out.

[Suvrutt_Gurjar · Accepted solution]

Please create a virtual column called say [Follow Up Date V] with an expression DATE([Follow up Date]) in the Call Logs table.

Then your slice expression can be

IN(TODAY(),[Related Call Logs][Follow Up Date V])