As an alternative you could try this. It use the Print indicator to strip blanks, and you can use a blank as the date component separator
truncate[apply.format["DDMY99 99 9999;;D";P1F1]] " " truncate[apply.format["THMS99 99;;D";P1F2]] Regards Brian _____ From: [email protected] [mailto:[email protected]] On Behalf Of Robert Pollard Sent: Tuesday, 20 December 2011 8:50 AM To: [email protected] Subject: Re: [Dataperf] Formula Gerard Sorry about that; I tried a shortcut without testing it. You're right, Juan Antonio. Should look like this now: cat.t[ apply.format [ "DDMY99" ; P1F1 ] ; apply.format [ "DMDY99" ; P1F1 ] ; apply.format [ "DYMD9999" ; P1F1 ] ; apply.format[ "THMS99" ; P1F2 ] ; apply.format[ "TMHS99" ; P1F2 ] ] Robert 2011/12/19 Juan A. Salhus R. <[email protected]> Gerard, you must cat[and apply format the date field to field eg. datemonthyear Juan Antonio _____ De: Gerard van Loenhout <[email protected]> Para: [email protected] Enviado: lunes 19 de diciembre de 2011 16:19 Asunto: Re: [Dataperf] Formula Chris, I'm afraid it doesnt work'. A date 27-02-2004 <tel:27-02-2004%20%C2%A0%2014> 14:00 comes out like: 00000027 HM0014 Gerard 2011/12/19 Robert Pollard <[email protected]> Gerard I think this should work, where P1F1 is the date field and P1F2 the time field: cat.t[ apply.format [ "DDMY99999999" ; P1F1 ] ; apply.format[ "THM9999" ; P1F2 ] ] Robert 2011/12/19 Gerard van Loenhout <[email protected]> Dear all, I need some help with a formula. I need to have a string in a text field. The data comes from a date and a time field 08-12-2009 11:44 Which is a date field (day-month-year) and a time field And as you can see we do not put the year first in a date field. It should come out in a report like this: 08122009 1144 Is that possible? Without the ' - ' and the ' : ' Regards Gerard van Loenhout
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
