Gerard,
Thanks for the reply. For some reason, I thought the year limitation in DP was 2052. This makes some sense because it ends in an even number. I believe endings in an odd number do not make sense in the binary world. In any case, it might muster up some discussion activity in the group so we can all wish each other a very Merry Christmas and a very Prosperous 2012 . the year the Mayan calendar ends . they were binary way back then when they developed the concept of the ZERO number and started their calendar!! All the best to all, Tony. From: [email protected] [mailto:[email protected]] On Behalf Of Gerard van Loenhout Sent: Tuesday, December 20, 2011 5:06 AM To: [email protected] Subject: Re: [Dataperf] Formula Tony, in my DP it is. I guess in yours too. Gerard 2011/12/20 Tony Perez <[email protected]> What is the well known year 2079? . is that a DP limitation? . or an elsewhere one? From: [email protected] [mailto:[email protected]] On Behalf Of Gerard van Loenhout Sent: Tuesday, December 20, 2011 12:05 AM To: [email protected] Subject: Re: [Dataperf] Formula Brian, the second one worked. We're happy. The first option gave the well known year 2079. Thanks to Robert and Juan as well for your efforts. Gerard 2011/12/20 Brian Hancock <[email protected]> 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 _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
