Convert Date Format...

[MrSatan]

Hi All,

Is there any function that can use to convert the date format from yyyymmdd into yyyy-mm-dd or from yyyy-mm-dd back to yyyymmdd?

Currently I need to use something like

SUBSTR(Date, 1, 4) + '-' + SUBSTR(Date, 5, 2) + '-' + SUBSTR(Date, 7, 2)

Thanks in advance.

MrSatan.

 

[baltman]

Try this out:

MyDate="20031130"
?MyDate

MyDate=TRANSFORM(MyDate, "@R ####-##-##&quot
?MyDate

MyDate=chrtran(MyDate,"-","&quot
?MyDate

Brian

 

[jimoo]

If that doesn't fit your needs, and you don't find a function to fit your needs, you can always create a user-defined-function (UDF) to do that for you.

* call udf
lcNewDate = MYDATE(DATE())


* udf
FUNCTION myDate
LPARAMETER tcDateIn

RETURN SUBSTR(tcDateIn, 1, 4) + '-' + SUBSTR(tcDateIn, 5, 2) + '-' + SUBSTR(tcDateIn, 7, 2)



Jim Osieczonek
Delta Business Group, LLC

http://www.deltabg.com

 

[MrSatan]

The suggestion from Brian is exactly what I want. Thank you very much for both of you.