On 2009 Jul 7, at 22:59, Lee wrote:
Hi,
I have a client that needs to export data for a buying group as a
CSV, file, no problems there however they require the date text to
read as a number yyyymmdd, 20090710. Can filemaker do this ?
Yup. The best way to do it is to create a Calculation field that
formats the desired date as yyyymmdd, then export the calculated
value instead of the original date. Assuming the original date field
is called "Date", here's how you'd get "Date Formatted":
Year ( Date ) & Right ( "0" & Month ( Date ); 2 ) & Right ( "0" &
Month ( Date ); 2 )
The funny stuff with the "Right" function is designed to ensure that
both the month and the day have exactly 2 digits, even tho the
"Month" and "Day" functions may return just 1.
