Skip to main content
alistair_4017
Participant
Jul 7, 2025 5:56 PM UTC
Question

PDF Services API - Regional Configuration. EU dates

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

    3 replies

    alistair_4017Author
    Participant
    Jul 25, 2025 9:45 AM UTC

    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.

    Translate
    Joel Geraci
    Community Expert
    Joel GeraciCommunity Expert
    Community Expert
    Jul 21, 2025 3:36 PM UTC

    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.

    Translate
    alistair_4017Author
    Participant
    Jul 21, 2025 3:47 PM UTC

    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

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