Hi Jan,
Oh! Ok. you can do all that with a far simpler formula convert["N99999999"; apply.format["DYMD9999 99 99;;D";P58F2] ] The field format : "DYMD9999 99 99" will produce the date with a space between each part and the Print Mode indicator ;;D will strip out the embedded spaces Regards Brian _____ From: [email protected] [mailto:[email protected]] On Behalf Of J. Hartman Sent: Monday, 23 November 2009 7:40 PM To: [email protected] Subject: [Dataperf] date conversion Hi Brian, Thank you for your elaborate answer! I found my solution at last: convert["N99999999"; substring[apply.format["DYMD9999-99-99";P58F2];1;4] substring[apply.format["DYMD9999-99-99";P58F2];6;2] substring[apply.format["DYMD9999-99-99";P58F2];9;2] ] Thanks again! Jan
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
