Skip to main content

Test Home
You & IATA

Search

You are here: Home » Services » Financial Services » Simplified Interline Settlement » SIS Forums
  • Print this page
  • Share this page

Date in F1FD report in csv format differs

This is a read-only copy of the discussions. To view the original, where you can reply, go here. For info on how to log in, please see the instructions.

Created by Marliyana M (Malaysia Airlines) on 2011-10-11 07:02:29 Back to Topics

Date in F1FD report in csv format differs

Hi,
 
Can you confirm what would be the correct date format for Form 1 From Debtors in .csv format? We found inconsistency between sample files that you provided against real file downloaded from ICH web.
 
Sample file format: MM/DD/YYYY
Real file from ICHWEB: YYYY-MM-DD
 
Please advise which one to follow because we are currently developing interface program to upload this file format.
 
Thanks!
Azuan
Replied by Ashley H on 2011-10-26 12:15:10

Dear Azuan,

 

The date format is YYYY-MM-DD.

 

With regards to the sample file, there may have been an issue with the regional settings on your local PC.

 

Hope this clarifies.

Regards,

Ashley

 

From: MOHD MUSLIM Marliyana
Posted At: October-11-11 7:02 AM
Posted To: SIS Forums - Requirements & Functionality
Conversation: Date in F1FD report in csv format differs
Subject: Date in F1FD report in csv format differs

 

Hi,

 

Can you confirm what would be the correct date format for Form 1 From Debtors in .csv format? We found inconsistency between sample files that you provided against real file downloaded from ICH web.

 

Sample file format: MM/DD/YYYY

Real file from ICHWEB: YYYY-MM-DD

 

Please advise which one to follow because we are currently developing interface program to upload this file format.

 

Thanks!

Azuan

 
ADVERTISEMENT


Additional information

© International Air Transport Association (IATA) 2014. All rights reserved.