Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Updating a Date Field Depending on the Time

Cfdiaz2103
8 - Asteroid

Hi Everyone!

 

I'm trying to fix a date field depending on the time at which a transaction was recorded in the bank. The parameter is that every transaction made after 19:00 will be registered on the next date.

 

Attached you can find an example.

 

I'd appreciate you response.  

7 REPLIES 7
atcodedog05
22 - Nova
22 - Nova

Hi @Cfdiaz2103 

 

Here is how you can do it. Extract hour compare and add.

 

Workflow:

atcodedog05_0-1626362948585.png

 

Hope this helps : )

 

Jean-Balteryx
16 - Nebula
16 - Nebula

Hi @Cfdiaz2103 ,

 

Does this workflow solve your problem ?

atcodedog05
22 - Nova
22 - Nova

Nice to see you after a long time @Jean-Balteryx 🙂

OllieClarke
15 - Aurora
15 - Aurora

Hi @Cfdiaz2103 

Try this:

OllieClarke_0-1626363144624.png

 

edit: @Jean-Balteryx's solution is nicer 🙂

 

Jean-Balteryx
16 - Nebula
16 - Nebula

Thank you @atcodedog05 ! 😉

Cfdiaz2103
8 - Asteroid

@Jean-Balteryx  It perfectly works!

 

Thanks!

Cfdiaz2103
8 - Asteroid

@atcodedog05 Thank you! It does. 😀

Labels
Top Solution Authors