convert string to yyyy mm dd

[rrmcguire]

Hello,

Im trying to convert a string which is written as 5/16/2005 to a date in the format yyyy mm dd.

So far Im using this syntax

dim str1 as string
dim strday as string
dim strmon as string
dim stryear as string
dim strdate as string
str1 = {Tractors_TTX.YEAR_PURCHASED}

stryear = left(str1,4)
strday = right(str1,2)
strmon = left(right(str1,4),2)

formula = stryear & strmon & strday


but its still showing month, day, year

any help would be appreciated.

 

[fisheromacse]

maybe something like this?

//{@datereorder}
numbervar mo := tonumber(split({Tractors_TTX.YEAR_PURCHASED},"/")[1]);
numbervar da := tonumber(split({Tractors_TTX.YEAR_PURCHASED},"/")[2]);
numbervar yr := tonumber(split({Tractors_TTX.YEAR_PURCHASED},"/")[3]);

yr &" "& da &" "& mo

 

[briangriffin]

date("5/16/2005")

evaluates properly to a date, then you can format the date as yyyy mm dd

 

[rrmcguire]

thanks brian that worked