Need quick help with date formula

[jstoehner]

I need a formula to convert "20070131" coming through the database as a number to date format -- 01/31/2007. I can't change the data type for the field on the database so how can I convert it in my CR? Thanks!

 

[KeertanaCR]

Try the following:

Create a formual @DateValue
StringVar No_Date_To_Txt_Date := totext(20070131, "0");
date(val(left(No_Date_To_Txt_Date,4)),val(mid(No_Date_To_Txt_Date,5,2)),val(right(No_Date_To_Txt_Date,2)))

Hope this helps!

Thank you
Keerthana!

 

[lbass]

That should be:

StringVar No_Date_To_Txt_Date := totext({table.number},0,"");

The rest looked right to me.

-LB

 

[jstoehner]

Perfect! I love this forum!!

Cheers,