Skip to main content
A
alistair_4017
Participant
July 7, 2025
Question

PDF Services API - Regional Configuration. EU dates

  • July 7, 2025
  • 2 replies
  • 223 views

Hello.

We have Excel spreadsheets with UK dates (dd/mm/yyyy).

When I convert them to PDF using the API the dates come back as US (mm/dd/yyyy).

This is odd as any other 3rd party method does not convert dates, and surely Adobe shouldn't be modifying contents unless specified within the API.

Our client will not accept dates in that format.

 

I have changed the endpoint to EU (https://pdf-services-ew1.adobe.io ) as per the Regional Configuration setting to no benefit.

 

We are on the free tier but notice the sentence in the API documentation "Once you purchase PDF Services API, its APIs can be configured to process the documents in a specified region that is listed below."

I'm going to assume this is the issue when on the free tier.

Any help will be most appreciated.

 

Regards

Alistair

    2 replies

    A
    alistair_4017Author
    Participant
    July 25, 2025

    To close this off.

    The problem lay with the cell format.

    An Excel guy had a look and fixed it for us. Something to do with the macros on the file.

    Sorry, I can't be more specific as I didn't really understand as Excel is not my thing.

    Joel Geraci
    Community Expert
    Joel GeraciCommunity Expert
    Community Expert
    July 21, 2025

    Don't rely on the default screen presentation of the date, which is dependent on the local time zone. Set the date format for the local you want. See image.

    A
    alistair_4017Author
    Participant
    July 21, 2025

    Thank you Joel.

    We will check the Spreadsheet's language.

    Although we have assumed it was English (UK) as it comes from a UK source.

     

    Regards

    Alistair

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices