Transform a Timestamp Column So "Filter By Date" Pane Can Be Used But It Still Not Recognized

[egraha11]

Hello, 

I see similar questions related to transforming a timestamp column so it can be recognized by the "Filter By Date" pane but it is not working for me. My steps are:

1.) Enter Data Manager ->Add field -> Calculate field and create a new field based on an already exist timestamp field with this expression: Date(Floor(request_dt))

2.) Then tried to add this column to a "filter by date" pane and it does load so I assume it is not recognizing as a Date.

timestamp format is: 1/1/1900 12:00:00 AM

Screenshots of the timestamped column and the created "Date" column are attached. Thank you. 

[mpc]

Hi, 

Maybe Date(Date#(Floor(request_dt),'M/D/YYYY')) ? 

Kind regards

[mpc]

I've put a mask, you should adapt it to your case

[egraha11]

Thank you for the responses, I got help from a BI developer. The steps to the solution are:

1.) In the Data manager, make sure to have the field type for "request_dt" set to Date and M/D/YYYY in both the Input format and Display format (my timestamp field was formatted as 1/1/1900 12:00:00 AM and my timestamp column is labeled "request_dt"). Then hit the load button

2.) In the Data Load Editor create a new script section using the "+" button and add the following line to this new section 

Tag Field request_dt with '$date'; 

Then hit Load data again.

I was able to filter by Date using the Date Picker Object after these steps.