[Justin Roper]

Thanks for your help – all sorted now! Using yyyymmdd did the trick and by playing around with the column headers

Justin

[Justin Roper]

Hi I’ve reimported the dates in US format (mmddyyyy) and I’m still seeing dates presented as 1st Jan 1970.

I’ve attached the updated import file for you.

Please note I’d like to be able to manage dates in ddmmyyyy format for the UK.

Kind regards

[Justin Roper]

This reply is private.

[Justin Roper]

Hello Sky

I’m replying directly as when I click on the support tickets page all I get
is a page not found error.

I’ve attached the spreadsheet for you to try.

Kind regards

Justin Roper
e-Learning | ICT | Assessment | Systems
Haslingden High School
Broadway, Haslingden, Lancashire BB4 4EY
*www.haslingdenhigh.com *

—

This e-mail contains information intended for the addressee only. It may
be confidential and may be the subject of legal and/or professional
privilege. If you are not the addressee you are not authorised to
disseminate, distribute, copy or use this e-mail or any attachment to it.
The content may be personal or contain personal opinions and unless
specifically stated or followed up in writing, the content cannot be taken
to form a contract or to be an expression of Haslingden High School’s
position. Haslingden High School reserves the right to monitor all incoming
and outgoing email.

Haslingden High School has taken reasonable steps to ensure that outgoing
communications do not contain malicious software and it is your
responsibility to carry out any checks on this email before accepting the
email and opening attachments.

[Author]

Posts