Power Platform Community Forum Thread Details

I've posted a coupe of times recently with date struggles. Hopefully this will be the last question.

I'm processing invoices and populating a workday EIB excel template.

The template has a field for date, but my 'date' field from PAD still seems to be text.

e.g.
here I have populated a couple of rows of dates. You can see the highlighted cells are formatted as a date.

But, excel doesnt seem to have converted the PAD input as a date field correctly. If I double click into the cell you can see the alignment shift to the right and the input converted to a 'date'

All I have done here is double click the top date cell and it is now a correct excel 'date'. This wouldn't normally be an issue but Workday wont process the file without correct date fields.