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
