Dates all over the place with upload
By Guest on Monday, 27 March 2017
Posted in JEvents (Free Access)
Replies 3
Likes 0
Views 791
Votes 0
Hi, Trying to upload the attached csv file, but it's putting events on random dates. Is it the file or extention? Probably the former

Thanks
Hello,

So you don't have any time on the CSV for start and end dates. if they are all day they should start: 00:00:00 and finish: 23:59:00

And try changing the format to so it is:

YYYY-MM-DD hh:mm:ss

Many thanks
Tony
Guest
·
Monday, 27 March 2017 20:51
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks for the reply. Tried changing to that format, but when I save the csv it reverts to dd/mm/yyyy 00:00:00
Guest
·
Tuesday, 28 March 2017 10:30
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello,

You need to change the column. Are you using excel? If so you need to right click format and change the date format.

Many thanks
Tony
Guest
·
Wednesday, 29 March 2017 10:06
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post