you can just do a text conversion

 

You formulas on numbers to date fields have been a great help. Can you help me clarify this error when I try to create a parameter field using the your above referenced formula- I get a 'bad date format string' error.

 

I need to create a parameter field which allows you to select a ship date for which records to display.

 

Thank you

 

I used the following fomula to convert it to a date field;

 

date(mid(totext({oeordhdr_sql.shipping_dt},0,''),5,2)+'/'+ right(totext({oeordhdr_sql.shipping_dt},0,''),2) + '/'+ left(totext({oeordhdr_sql.shipping_dt},0,''),4))

 

Now Im trying to use this formula field as a parameter to select a date which to display records for. Thats where Im getting the "bad date format string" error.

 

The selection formula is ;

 

{@Ship Date\} = Date (2013, 01, 02)

 

Is this the problem?

 

Appreciate your help-