How can I Remove HH:MM:SS from a Date Format using Formula Tool
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Community,
How can I Remove HH:MM:SS from a Date Format using Formula Tool
Example in my column L_CREATION_DATE the Date is coming as 22/02/2023 14:51:19 I want to show it as 22/02/2023 how do I do this can someone please explain
TIA,
Karl.
Solved! Go to Solution.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @Karl_Spratt, although you could parse and reformat the DateTime, if the field format is consistent then you could just pull the left 10 characters that cover the date:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Karl_Spratt,
If the date input is Datetime format, you can simply add a select tool and change its datatype in the tool to Date. This should work.
Else, if the datatype of input is String, use the 'DateTime' tool from 'Parse', change it to datetime, and then use select tool. Within select you can change the data type to 'Date' as in the above snip.
This is the configuration for the 'DateTime' tool:
Please like or mark it as solution if it helped :)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks all for your help, it was in Date/Time, so changing to just Date worked.
Thanks again Community for all your help here.
Regards,
Karl.
