Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
egraha11
Contributor
Contributor

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

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. 

Labels (1)
3 Replies
mpc
Partner - Specialist
Partner - Specialist

Hi, 

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

Kind regards

From MPC (and Next Decision) with love
mpc
Partner - Specialist
Partner - Specialist

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

From MPC (and Next Decision) with love
egraha11
Contributor
Contributor
Author

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.