10-31-2017 10:44 AM
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.
Solved! Go to Solution.
10-31-2017 10:54 AM
I have found the Help for the Format Date/Time String Function to be quite useful.
Not sure what you are using.
10-31-2017 10:59 AM
I have looked there but find the answer I was looking for
10-31-2017 11:01 AM
@morrissey89 wrote:
I have looked there but find the answer I was looking for
Didn't find or didn't understand.
Different.
10-31-2017 11:03 AM
sorry - could not find the answer.
10-31-2017 11:04 AM
You should show us what you actually TRIED.
10-31-2017 11:09 AM - edited 10-31-2017 11:09 AM
Perhaps the Format Codes for the Time Format String would be helpful.
10-31-2017 11:17 AM
I guess he was looking very hard.
10-31-2017 11:24 AM
you can do it like this using 'search and replace string'