We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to add time to a date

Dittau
8 - Asteroid
‎05-19-2023 10:12 AM

Hello,

 

I need to create a dynamic date and then add a static time next to the date 11:43:05

 

How do i do this in the formula tool?

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

1 REPLY 1
cjaneczko
13 - Pulsar
‎05-19-2023 10:21 AM

Try the following in a Formula tool. Replace [DateTime_Out] with the field that contains your date.

 

DateTimeFormat([DateTime_Out],'%m/%d/%Y')+' 11:43:05'

 

cjaneczko_0-1684516889832.png

 

Reply
0 Likes
Copilot AMA
Live Office Hours
Labels
Top Solution Authors
View All