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
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf

Reply via email to