Date Conversion

[ravikumarreddy]

Hai All,

I have a date field of the format 1/1/2005 and my output should look like 2005-01-01. How can i achieve this. Thanx in Advance

Regard's
RAVI

[ArndW]

Take a look in the Documentation and also in this forum at the StringToDate and DateToString functions.

[ravikumarreddy]

Hai ArndW,

i have tried using StringToDate(ip.date,"%yyyy-%mm-%dd")
iam getting the output as

"**********",2005,1,1,1,7,1,1,1,31,"SATURDAY","JANUARY

Regard's
RAvi

[ArndW]

The output shows that the conversion wasn't successful, either because of a bad format or a bad input type date. If you are getting a Date type field from a database, you would first need to DateToString and then a StringToDate with the new format.

[ray.wurlod]

StringToDate(ip.date,"%yyyy-%mm-%dd") specifies that the input string is in YYYY-MM-DD format. This is not how you originally represented the problem.
What you probably need is something of the form

Code: Select all

DateToString(StringToDate(ip.date,"%mm/%dd/%yy"), "%yyyy-%mm-%dd")

[ravikumarreddy]

Hai Ray,

StringToDate function is working if my input date is 01/01/2005(having length 10). It is not working if the input data is 1/1/2005(having the length .Why is it so. Thanx in Advance

Regards
Ravi

[ravikumarreddy]

hai Ray,

I have got the output in this way

StageVariable1
if Len (Field(DSLink2.date_f,"/",1))=1 then "0":Field(DSLink2.date_f,"/",1) else Field(DSLink2.date_f,"/",1)
StageVariable2
if Len (Field(DSLink2.date_f,"/",2))=1 then "0":Field(DSLink2.date_f,"/",2) else Field(DSLink2.date_f,"/",2)

Concatenating both
StringToDate(Right(DSLink2.date_f,4):StageVar1:StageVar,"%yyyy%mm%dd")

I have got the result by doing this.

But i need to do it in simpler way. Any suggestions

Regard's
Ravi

[lshort]

This works...a little simpler...maybe

svDay
((Field(DSLink3.f1,'/',1))/100)[3,2]
svMonth
((Field(DSLink3.f1,'/',2))/100)[3,2]
svYear
Field(DSLink3.f1,'/',3)


StringToDate(svMonth:'/':svDay:'/':svYear,"%mm/%dd/%yyyy")

[lshort]

btw: You could also do it all in the derivation without the StageVariables

StringToDate(((Field(DSLink3.f1,'/',2))/100)[3,2]:'/':((Field(DSLink3.f1,'/',1))/100)[3,2]:'/':Field(DSLink3.f1,'/',3),"%mm/%dd/%yyyy")