Alert: There is a planned Community maintenance outage October 16th from approximately 10 - 11 PM PST. During this time the Alteryx Community will be inaccessible. Thank you for your understanding!
community Alteryx IO Mission Control
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

custom date

AustinBauer
7 - Meteor
‎09-25-2018 08:16 AM

Hi I currently have a date like this 1/29/2018 and I am trying to padleft to put a "0" at the beginning of this date. However, it is not working for me. 

 

My date is currently in a V_String format and I am using this formula: 

 

PadLeft(ToString([START DATE]), 2, "0")

Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

4 REPLIES 4
tcroberts
12 - Quasar
‎09-25-2018 08:19 AM

Is there a reason why:

 

"0" + [START DATE]

 

wouldn't work here? I'm looking into why your implementation isn't working, but I think it can be done in a much simpler way.

 

Let me know if this helps,

 

Cheers!

Reply
0 Likes
ponraj
13 - Pulsar
‎09-25-2018 08:35 AM

You can also use date time tool to get the desired results. 

 

 

 

WorkflowWorkflowResultsResults

custom date.yxmd
Reply
AustinBauer
7 - Meteor
‎09-25-2018 08:54 AM
The issue then becomes I have dates that will look like "010/29/2018". Months 10,11, and 12 have an extra 0 in front. This would work, but what formula could I use to remove this leading 0 on these 3 months?
Reply
0 Likes
ponraj
13 - Pulsar
‎09-25-2018 09:03 AM

The workflow I shared will work for your case.  Just share the sample data with all the possible combination in case the workflow I shared not working. 

Reply
0 Likes
Labels