Updating a Date Field Depending on the Time

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.

Updating Transaction Date.xlsx

Date Time

Accepted answers

atcodedog05

Hi @Cfdiaz2103

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

Workflow:

Hope this helps : )

hour.yxmd

Jean-Balteryx

Hi @Cfdiaz2103 ,

Does this workflow solve your problem ?

date_19.yxmd

OllieClarke

Hi @Cfdiaz2103

Try this:

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

time.yxzp

All comments

atcodedog05

Hi @Cfdiaz2103

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

Workflow:

Hope this helps : )

hour.yxmd

Jean-Balteryx

Hi @Cfdiaz2103 ,

Does this workflow solve your problem ?

date_19.yxmd

atcodedog05

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

OllieClarke

Hi @Cfdiaz2103

Try this:

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

time.yxzp

Cfdiaz2103

@Jean-Balteryx It perfectly works!

Thanks!

Cfdiaz2103

@atcodedog05 Thank you! It does. 😀

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703