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

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

egraha11 — Wed, 22 May 2024 16:52:24 GMT

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.

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

mpc — Wed, 22 May 2024 17:03:31 GMT

Hi,

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

Kind regards

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

mpc — Wed, 22 May 2024 17:04:22 GMT

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

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

egraha11 — Tue, 28 May 2024 13:30:34 GMT

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.