Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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