Help with the following code:

[ridsey]

I was given the following code to insert into my row to perform a date conversion, however it gives me an error, and im not too sure if im doing something wrong, or it there is a problem in the code.

@DATE(@TRUNC(A1,-4)/10000+@IF(A1<=90000,100,0),@TRUNC(@MOD(A1,10000),-2)/100,@MOD(A1,100))

thanks

ridsey

 

[ridsey]

Nevermind, i got it work, just a stupid mistake on my part!

thanks again crazybird for the help, i really appreciate it!