Question Re: Date Format Excel Build Process Automation in Technology Q&A

Date Format Excel Build Process Automation

BillGiotDel — Mon, 28 Nov 2022 14:58:02 GMT

I am following the learning journey of SAP Build and came across a date format error:

The Excel Data:

I tried multiple date formats but none of them work.

How can I make sure that the date is readable without having to change the Excel file? (it loses it's purpose if we have to change it every time an excel file comes in)

Thanks in advance!

Re: Date Format Excel Build Process Automation

Armarda — Mon, 28 Nov 2022 17:17:56 GMT

I would try the american format i.e. yyyyddmm - without any separators i.e. no / or .

Re: Date Format Excel Build Process Automation

BillGiotDel — Tue, 29 Nov 2022 09:13:27 GMT

Thank you for your quick response!

I tried it but it doesn't seem to work either:

Re: Date Format Excel Build Process Automation

shamichi — Fri, 02 Dec 2022 13:38:19 GMT

Hi Giot Bill,

I see somthing strang in the second try with american format. It still says in the error message that: The value 22/1/2022 cannot be formatted as date.

Is there any chance that you are not updating the right excel?

Best regards,

Samir Hamichi

Re: Date Format Excel Build Process Automation

BillGiotDel — Fri, 02 Dec 2022 18:58:12 GMT

Hi Samir Hamichi,

I tested it again. What I notice is there is no date format like "yyyyddmm".

I changed the format to a custom format "yyyyddmm".

But this still gives me the error.

Best Regards,

Bill Giot