Skip to Content
Oct 13 at 02:39 PM

How to convert DateTime field to Date field or create calculated dimension for it


In one of our data sources in SAP analytics cloud, we have a field called "Start Date" which has the values with Date and Time information. But what is required is just a Date information to create date filter. (As the data contains Date with default 00:00:00 Time)

So I tried creating a calculation dimension, based on this field, but I am not able to create it, as TODATE function is throwing the below error

So basically what I want to achieve is to create a filter without time information, which currently looks as below

Can anyone help me to resolve this issue and achieve this filter without time information?