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