Skip to Content
author's profile photo Former Member
Former Member

0Calday

Can any one tell.. what should be for mat for 0calday field in flat filee.g for date filed it is YYYYMMDD

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Oct 22, 2005 at 06:20 AM

    Hi,

    Didn't get your question. Date field format in flat file should be as you wrote: YYYYMMDD. What exactly do you want to know?

    Best regards,

    Eugene

    Add a comment
    10|10000 characters needed characters exceeded

    • YYYYMM is an internal fotmat for 0CALMONTH, MMYYYY – external.

      If you use a std 0CALMONTH IO, then a PERI6 conversion routine is used.

      There is info about it.

      <b>Use</b>

      Conversion routine PER16 is used with six-digit entries for (business year) periods.

      <b>Functions</b>

      The internal format for six-digit periods is YYYYPP (200206, for example, for period 6 of business

      year 2002). As the external format is converted to the internal format, this checks whether the

      entries in the INPUT parameter with external date formatting (separators, order) comply with user

      settings. The separator (‘.’ or ‘/’) has to correspond to the date format in the user settings.

      Different abbreviated entries are possible and these will be correctly converted into the internal

      format.

      <b>Example</b>

      For the external date formatting DD.MM.YYYY in the user settings, the following conversion takes

      place from external to internal formats:

      ...

      1. '12.1999' -> '199912'

      2. '1.1999' ->'199901'

      3. '12.05' -> '200512'

      4. '1.99' -> '199901'

      5. '102005' -> '200510'

      Best regards,

      Eugene

      Message was edited by: Eugene Khusainov

  • author's profile photo Former Member
    Former Member
    Posted on Oct 22, 2005 at 06:19 AM

    hi,

    yes, in flat file its YYYYMMDD

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.