DSXchange

Hi

i have input field as 09062007 and the output is the date format
i am using the string to date function

StringToDate(DSLink3.col1,"%dd-%mm-%yyyy")

but in the output i am getting "**********"

and similarily for one field i need to convert the same input to timestamp but it is also giving the * values

please suggest..

Hi

Here the second parameter should always represent your input string format.

yes i agree it is in the same format please take a look one more time

use the function as

StringToDate(DSLink3.col1,"%dd%mm%yyyy") .
This will work.

what if i want the output in the format mm/dd/yyyy

It depends on the default format defined at you project level.

StringToDate(inputcolumn,[input date format](in your case it is "%dd%mm%yyyy")).

The output for this function will be based on project level parameter which is set in Administrator client for this project.

But you can override with necessary format based on your requirement in job parameters.

go to job parameters--- default tab--- then change format defaults according to your requirement.

thanks kiran its working fine for me now

Hmmm... DATE datatypes don't have formats, people.