Date format

• 

  bathroombuddy

  Posted: 14.01.2022 17:20

  Modified: 20.11.2024 19:56

  I have built up a large database of readings over the past year using data exported by excel. Why has the date fornat now suddenly changed to the US format of mm/dd/yy??? Is there any way you can revert back to the UK convention please

   

  It would also be great if the exported data had the date and times in separate columns!
• 

  aranet-techsupport

  Posted: 14.01.2022 17:36

  We are sorry for the inconvenience. Date format conversion is in the list of future improvements.
• 

  aranet-techsupport

  Posted: 14.01.2022 18:16

  Modified: 14.01.2022 18:17

  Meanwhile, you can split Date and time column into two separate columns and change date format in Excel.

  1.  Import exported .csv file into Excel spreadsheet.:
     
  2. Insert new empty column after the first ("Time") column:
     
  3. Select the entire first column.
  4. Choose DATA menu -> Text to Columns:
     
  5. Select Delimited -> Next:
     
  6. Mark Space -> Next:
     
  7. Mark the first column and Select Date and choose MDY format; leave the second column as is and press Finish:
     

  Now you have separate columns for Date and Time and can format then as you like:
  

   
• 

  ernests

  Posted: 27.04.2022 11:26

  Hi,

  date format can be set up in Aranet4 app settings starting from 3.0.2 version. 

  supported formats to choose - dd/mm/yyyy and mm/dd/yyyy

You have to log in to reply.