- Inside the Alteryx workflow designer, go to the left-side panel and find 'Formula'. Drag this tool onto the canvas and connect it to the Input Data tool or other sources.
- Following that, head over to the right-side panel and configure the selected tool according to your preferences. To get started, enter your preferred Output Column name into the provided input field and then set the Field Type you wish to use.
- Click the Formula field afterwards, then type 'DateTimeFormat' and select it from the suggested results.
- Subsequently, replace DT with '[' and choose the field that contains the data you want to use.
- Replace F with '%Y-%m-%d' to indicate a new date format without time. Make sure that it is enclosed in a pair of quotation marks.
- Finally, the time will be removed from the date in your Alteryx data.
How to Remove the Time From the Date in Alteryx
Follow this interactive demo to learn how to remove the time from the date in Alteryx.
📌 Why this matters
Removing time from dates enables you to group records by day, perform accurate date-based aggregations, and create cleaner reports where hourly precision is irrelevant. Beyond basic formatting, this transformation is essential for joining datasets that store dates differently - some with timestamps, others without. When you're merging customer transactions with daily targets or matching sales data across systems, inconsistent date formats will cause joins to fail. Standardizing to date-only format ensures your data relationships work correctly and your analysis captures all relevant records.
Your product deserves an interactive demo
Similar Articles
No items found.