question

Upvotes
Accepted
791 11 16 19

Valid RWF DATE and TIME formats for ATS contribution

Does anyone know all the valid formats that are accepted by ATS for contribution to DATE and TIME fields?

I know that for DATE the accepted formats are “DDMMMYYYY” or “DD MMM YYYY”.

Can anyone confirm all the formats for TIME?

elektronrefinitiv-realtimetrepATS
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Upvotes
Accepted
401 21 25 35

TREP-RT currently supports the MF date format of DD Mmm YYYY for conversion to RWF. The following additional MF

date formats are supported. A combination of uppercase/lowercase will also be supported for non-numeric date fields. Dates in any other formats are blanked out during conversion.

  • DD-Mmm-YYYY (e.g.: 27-Jan-2012)
  • DDMMMYY (e.g.: 20MAR12)
  • DDMmmYYYY (e.g.: 21Jul2011)
  • DD Mmm YY (e.g.: 01 Aug 07)
  • DD/NN/YYYY (e.g.: 01/11/2010)
  • DD/NN/YY (e.g.: 01/11/10)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.