string to date

vishal_rastogi · Post by **vishal_rastogi** » Mon Aug 01, 2011 2:56 am

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..

kamtammystuff · Post by **kamtammystuff** » Mon Aug 01, 2011 3:13 am

Hi

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

vishal_rastogi · Post by **vishal_rastogi** » Mon Aug 01, 2011 3:21 am

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

kiran0435 · Post by **kiran0435** » Mon Aug 01, 2011 3:24 am

use the function as

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

vishal_rastogi · Post by **vishal_rastogi** » Mon Aug 01, 2011 3:31 am

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

kamtammystuff · Post by **kamtammystuff** » Mon Aug 01, 2011 3:37 am

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

kiran0435 · Post by **kiran0435** » Mon Aug 01, 2011 3:39 am

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.

vishal_rastogi · Post by **vishal_rastogi** » Mon Aug 01, 2011 3:57 am

thanks kiran its working fine for me now

chulett · Post by **chulett** » Mon Aug 01, 2011 6:27 am

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

DSXchange

string to date

string to date

Re: string to date