How can I remove dashes in a date format?

[Virupan]

Hi,

How can I convert date format from 'yyyy-mm-dd' to 'yyyymmdd' format ? Which is the date function to be used.Please let me know.


Thanks

**Note: Subject changed to be more descriptive - Content Editor **

[swarnkar]

[quote="Virupan"]Hi,

How can I convert date format from 'yyyy-mm-dd' to 'yyyymmdd' format ?

You can delete " - " by using EREPLACE function

EREPLACE(columnName,"-","")

Nitin Swarnkar

[akarsh]

Hi,

How can I convert date format from 'yyyy-mm-dd' to 'yyyymmdd' format ?

You can delete " - " by using EREPLACE function

EREPLACE(columnName,"-","")

Nitin Swarnkar

u can also do like

date[1,4]:date[6,2]:date[9,2]

[mk_ds09]

u can use trim also to remove the '-' ..
Use option as 'A'..

if you want to do it in unix ..use cut -c

hope this helps

--
Mk

[DSguru2B]

Or you could use the good ol' ICONV/OCONV conversions

Code: Select all

OCONV(ICONV(in.date, "D-YMD"), "DYMD":@VM:"MCN")

The second conversion code of "MCN" will strip away the spaces.

[chulett]

Just the OConv is all that's really needed in this case... or use the DIGITS transform which makes the same function call under the covers but is a little easier on the eyes.

[DSguru2B]

You are absolutely right Craig. Just an OCONV with "MCN" will do the trick.

[ray.wurlod]

The most efficient way, in this particular case, is to use Convert() function to change the "-" characters to "".

Code: Select all

Convert("-", "", InLink.TheDate)