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

Change date

Cheshta22
6 - Meteoroid

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.

2 REPLIES 2
ShankerV
17 - Castor

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
ShankerV_2-1677760853193.png

 

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
6 - Meteoroid

Done! Sorted :)

 

 

 

 

Labels