Change date

[Cheshta22]

I have a mixture of date and time format in GMT timings example if it says 3/10/2000 23:00:00 the actual date would be 4/10/2000. If the data is 3/10/2000 00:00:00 then no changes required.

Can someone please help to get this sorted.

[ShankerV]

Hi @Cheshta22 

Below, I outlined the steps you can follow to build your own solution workflow.

Why should you try to build it yourself?

[1. It reduces professional risk] You might be tempted to copy a provided solution workflow. If you implement it without learning and understanding proper use, you risk it failing and being unable to fix it.

[2. You will increase personal proficiency] If you invest in understanding the concepts and build the solution yourself, you will be able to build workflow solutions better and more efficiently in the future.  

Build your own solution guide

1. Input your data with Column you want to process

2. Use the Formula tool, to derive the output.

Column name: Output or any desired name or you can overwrite in the same column

Formula: 

IF left(Right([Field1],8),2)="23"
THEN
datetimeformat(datetimeadd(datetimeparse([Field1],"%d/%m/%Y"),1,"days"),"%d/%m/%Y")
ELSEIF left(Right([Field1],8),2)="00"
THEN [Field1]
ELSE [Field1]
ENDIF

We encourage you to try it yourself. Refer to the below section only if you are stuck

Spoiler

Kudos to you! If you were able to build the solution yourself :)

Please share with us if you were able to successfully build it or if you are facing any issues.

Happy to help :)

You can learn more about how to use Datetime tools to build your own solution with the help of 

https://help.alteryx.com/20223/designer/datetime-functions

Many thanks

Shanker V

[Cheshta22 · Accepted solution]

Done! Sorted :)