Converting number to Date

[pdef]

I have a situation where a date is stored as a number in format yyyymmdd. That is 20090828 would be August 28 2009. I need to be able to display that at 08/28/2009. Any ideas?

 

[pdef]

Sorry for the lack of details here. I am using CR XI R2.

 

[fisheromacse]

something like this...

stringvar x := {table.numberdatefield};
Date(val(left(x,4)),val(mid(x,5,2)),val(right(x,2)))


Also, this from the FAQ....

http://www.tek-tips.com/faqs.cfm?fid=3539

...but i was unable to open the link.

 

[fisheromacse]

oh,
i should give all credit for the original formula to lbass!
thanks!!

 

[lbass]

Actually, I think you saw that in a thread where I made an initial mistake by not converting the number to a string, so it should be:

stringvar x := totext({table.numberdatefield},0,"");
Date(val(left(x,4)),val(mid(x,5,2)),val(right(x,2)))

Then you could format it to display however you like.

-LB

 

[pdef]

Thank you for the info. I think I am on my way to a solution.