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
