I have solved the problem at last with the help of Ralph's book. The formula is:
convert["N99999999"; apply.format["N9999";year[P50F6] apply.format["N99;;S";month[P50F apply.format["N99;;S";day[P50F6] ] Thank you for your suggestions, Jan -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of J. Hartman Sent: dinsdag 30 december 2008 13:11 To: 'Dataperfect Users Discussion Group' Subject: RE: [Dataperf] Date conversion I'm afraid that does do the trick! Jan -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Michael Iannantuoni Sent: dinsdag 30 december 2008 13:05 To: Dataperfect Users Discussion Group Subject: Re: [Dataperf] Date conversion Hi Jan Try apply.format["DYMD99999999";P1F1] where P1F1 is your date field. Michael J. Hartman wrote: Dear All, What formula converts a date in a DDMY99-99-9999 date field to an 8-digit numeric N-field? f.i. change "31-12-2008" to 20081231 Whatever I tried I cannot get it done. Jan Hartman __________ Informatie van ESET NOD32 Antivirus, versie van database viruskenmerken 3723 (20081230) __________ Het bericht is gecontroleerd door ESET NOD32 Antivirus. http://www.eset.com _____ _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf __________ Informatie van ESET NOD32 Antivirus, versie van database viruskenmerken 3723 (20081230) __________ Het bericht is gecontroleerd door ESET NOD32 Antivirus. http://www.eset.com __________ Informatie van ESET NOD32 Antivirus, versie van database viruskenmerken 3723 (20081230) __________ Het bericht is gecontroleerd door ESET NOD32 Antivirus. http://www.eset.com
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf __________ Informatie van ESET NOD32 Antivirus, versie van database viruskenmerken 3723 (20081230) __________ Het bericht is gecontroleerd door ESET NOD32 Antivirus. http://www.eset.com
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
