Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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
20 - Arcturus

Hi @Cfdiaz2103 

 

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

 

Workflow:

atcodedog05_0-1626362948585.png

 

Hope this helps : )

 

Jean-Balteryx
15 - Aurora

Hi @Cfdiaz2103 ,

 

Does this workflow solve your problem ?

atcodedog05
20 - Arcturus

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

OllieClarke
13 - Pulsar
13 - Pulsar

Hi @Cfdiaz2103 

Try this:

OllieClarke_0-1626363144624.png

 

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

 

Jean-Balteryx
15 - Aurora

Thank you @atcodedog05 ! 😉

Cfdiaz2103
8 - Asteroid

@Jean-Balteryx  It perfectly works!

 

Thanks!

Cfdiaz2103
8 - Asteroid

@atcodedog05 Thank you! It does. 😀

Labels