BSBI Distribution Database > message board

Download date format

Any queries about using the BSBI database

Download date format

by Gustav Clark » Wed Apr 14, 2021 2:20 pm

Is it possible to specify the date format in downloads? The default seems to be yyyy-mm-dd, which at least my version of Excel does not recognise as a date.
Gustav Clark
Posts: 1
Joined: Thu Jan 14, 2021 10:30 pm
name: Gustav Clark

Re: Download date format

by AndyAmphlett » Fri Apr 16, 2021 9:21 pm

Specifying date format can't be specified that I can see; Tom would have to advise. But you can convert the text format date to date format.

Insert an additional column.
Use the formula =datevalue() to generate the date in number format.
Select the resulting cells and right click Format cells > Date
Copy the results and use paste values back into the same cells.
You now have the cells in date format.

Hope that helps.

Posts: 402
Joined: Fri Nov 23, 2012 9:32 am
name: Andy Amphlett

Return to Help and support