Categories
Categories:   All Categories
Suggested keywords
x
New
 Issue

Dates all over the place with upload

JEvents (Free Access)
  JEvents (Free Access)
Rebelt
  Rebelt
  Monday, 27 March 2017
  3 Replies
  1K Visits
0
Votes
Undo
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
Oldest First  
tonyp
tonyp
Monday, 27 March 2017 20:51
·
#185939
0
Votes
Undo
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
Rebelt
Rebelt
Tuesday, 28 March 2017 10:30
·
#185981
0
Votes
Undo
Thanks for the reply. Tried changing to that format, but when I save the csv it reverts to dd/mm/yyyy 00:00:00
tonyp
tonyp
Wednesday, 29 March 2017 10:06
·
#186040
0
Votes
Undo
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
  • Page :
  • 1
There are no replies made for this post yet.