issues with dates on csv files | General | Forum

Avatar

Please consider registering
Guest

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
Advanced Search

— Forum Scope —






— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Feed sp_TopicIcon
issues with dates on csv files
No permission to create posts
May 31, 2014
7:18 pm
Avatar
kenkoknz

Silver
Members
Forum Posts: 5
Member Since:
May 31, 2014
sp_UserOfflineSmall Offline

Hi,
i uploaded a cvs file with about 60 datapoints (3 fileds); the first date is 16 april 14 (16/04/14); however on the graph is show different dates, the first date is shown as 6th jan 14 and the rest of the dates are worng on the graph, however i exported the data and the csv files show the correct dates. Any ideas?
thanks,
ken

June 1, 2014
12:14 pm
Avatar
lee

Admin
Forum Posts: 457
Member Since:
March 14, 2011
sp_UserOfflineSmall Offline

Hi Ken,

I'll take a look at this issue, can you email the CSV file to: support at iobridge dot com?

lee

June 3, 2014
1:08 am
Avatar
kenkoknz

Silver
Members
Forum Posts: 5
Member Since:
May 31, 2014
sp_UserOfflineSmall Offline

Hi Lee,
Thnks for the response. I have email you the csv file, the public feed is: https://thingspeak.com/channels/12615

Cheers,
Ken

June 4, 2014
2:58 am
Avatar
kenkoknz

Silver
Members
Forum Posts: 5
Member Since:
May 31, 2014
sp_UserOfflineSmall Offline

Hi Lee,

Thanks for the advice, it was the date format that was the problem; Down under, we are used to the dd/mm/yyyy format. I manage to convert the date format using excel to yyyy-mm-dd and it works, even with the - in place of the /, so all good.

Excellent support and responsiveness.

Cheers,
Ken

Forum Timezone: America/New_York

Most Users Ever Online: 166

Currently Online:
17 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

rw950431: 272

Vinod: 240

piajola: 95

turgo: 70

vespapierre: 63

Adarsh_Murthy: 62

Member Stats:

Guest Posters: 1

Members: 8665

Moderators: 1

Admins: 2

Forum Stats:

Groups: 3

Forums: 14

Topics: 1600

Posts: 5760

Newest Members:

Team_mafia, icXu, emorphistechno, VTVMART, manimozhi, adamhebrew

Moderators: cstapels: 460

Administrators: Hans: 405, lee: 457