Results 1 to 2 of 2

Thread: date format

  1. #1
    Join Date
    Nov 2003

    Unanswered: date format

    Hi all,
    Here is a problem on date format since I did out put data set from FM into DBF format.
    For example, there is a person's DOB in FM field wiht date format as 2/18/1965, but if I out put it into DBF format, the DOB automatic changed to 2065-02-18. The system is WinXP and OfficeXP.
    Any suggestion for that?
    Thank you

  2. #2
    Join Date
    May 2004
    Melbourne, Australia
    Hello Kai,
    It sounds as though perhaps your data have been entered with two-digit years and are relying on layout formatting to 'interpret the dates for display.

    You might like to try running the export with the option to 'Apply current layout's data formatting to exported data' selected. That should filter the outgoing dates according to the display options of the layout.
    FileMaker Developer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts