string to date
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 47
- Joined: Thu Dec 09, 2010 4:37 am
string to date
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..
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..
Vish
-
- Participant
- Posts: 26
- Joined: Fri Feb 19, 2010 2:08 am
Re: string to date
Hi
Here the second parameter should always represent your input string format.
Here the second parameter should always represent your input string format.
-
- Participant
- Posts: 47
- Joined: Thu Dec 09, 2010 4:37 am
-
- Participant
- Posts: 47
- Joined: Thu Dec 09, 2010 4:37 am
-
- Participant
- Posts: 26
- Joined: Fri Feb 19, 2010 2:08 am
It depends on the default format defined at you project level.
Last edited by kamtammystuff on Mon Aug 01, 2011 4:40 am, edited 2 times in total.
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.
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.
-
- Participant
- Posts: 47
- Joined: Thu Dec 09, 2010 4:37 am