String Formating Date

[morrissey89]

Hello, this is most likely an easy thing to do but I am not great at formatting string data type.

What I am trying to do is take a time stamp (ex: 10/31/17) and format it to 10-31-17.

I am not sure have to change the "/" into "-" or remove it all together so the date is just 103117 that is fine too.

[njacacia]

I have found the Help for the Format Date/Time String Function to be quite useful.

Not sure what you are using.

[morrissey89]

I have looked there but find the answer I was looking for

[njacacia]

---

@morrissey89 wrote:

I have looked there but find the answer I was looking for

---

Didn't find or didn't understand.

Different.

[morrissey89]

sorry - could not find the answer.

[njacacia]

You should show us what you actually TRIED.

[crossrulz · Accepted solution]

Perhaps the Format Codes for the Time Format String would be helpful.

[njacacia]

I guess he was looking very hard.

[djac91 · Accepted solution]

you can do it like this using 'search and replace string'