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
  779 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
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!
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
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!
  • Page :
  • 1
There are no replies made for this post yet.