String to date format

[samuel.rajesh]

Hi ,

Am converting a string to date using the below transformer function (StringToDate(Lnk_Transaction_Read.ORDR_VLE_DT,"%yyyy%mm%dd"),
However the output is the following format "YYYY-MM-DD" how do i remove the "-" ,thanks in advance .


Sam

[edison]

Hi ,

Am converting a string to date using the below transformer function (StringToDate(Lnk_Transaction_Read.ORDR_VLE_DT,"%yyyy%mm%dd"),
However the output is the following format "YYYY-MM-DD" how do i remove the "-" ,thanks in advance .
by using e-replace command u can do that right,go in the help and write e-replace u will get clear idea to remove"-"

Sam

[ray.wurlod]

You don't need to remove the "-" characters - display of dates is governed by the default date format string you have defined. When Date data types are written to database tables, they are loaded as type Date; display format is ignored. If you are writing to a text file, don't use the Date data type, and simply trim the "-" characters from the string using Trim() or Convert() function.

[mcs_murali83]

Hi,

If you want to remove the double quotes, while u r importing the meta data
into your repository folder, a window pops up. In that specify " (double quotes) in that box.

(i.e) quote "