Hi Brian,
I read your mail with a sheepish grin. How easy! Thanks again, Jan -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Brian Hancock Sent: maandag 23 november 2009 21:16 To: [email protected] Subject: Re: [Dataperf] date conversion 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 __________ Informatie van ESET NOD32 Antivirus, versie van database viruskenmerken 4631 (20091123) __________ Het bericht is gecontroleerd door ESET NOD32 Antivirus. http://www.eset.com
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
