custom date

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")

Custom Tools

Common Use Cases

Data Investigation

Chained App

Alias Manager

Accepted answers

ponraj

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

Workflow Results Results

custom date.yxmd

All comments

tcroberts

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!

ponraj

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

Workflow Results Results

custom date.yxmd

AustinBauer

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?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703