Reformatting a date

Get help with installation and running here.

Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators

Post Reply

Reformatting a date

Post by Rusty »

Sorry for the noob question, but we are using datapipe/textpipe to try and reformat a date (in a varcvhar field). It currently is represented as:


And we need to insert hyphens:


What's the simplest method?

User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia

Post by DataMystic Support »

Use an EasyPattern

[ capture(4 digits), capture(2 digits), capture(2 digits) ]

replace with

Post Reply