Query Editor - Issue with coverting date format when year changes when date format is Day DD MMM e.g Sat 28 Dec

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
3,231
click on Error and it will tell you what kind of error is
 

Kerryx

Board Regular
Joined
May 6, 2016
Messages
78
DataFormat.Error:We couldn't parse the input provided as Date value
Details:
Sat 11 Jan
 
Last edited:

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
3,231
I think your source table contain dates stored as text not as date

select in source Sat 11 Jan and look at formula bar, if you see the same that means this is a text not a date
 
Last edited:

Kerryx

Board Regular
Joined
May 6, 2016
Messages
78
Probably is as it is in format at
Sat 28 Dec
Wed 22 Jan
Sat 1 Feb

everything prior to Wed 1 Jan converts to date ok as I assume it looks and takes current system year for date but runs into trouble when it hits Jan 1 as It cannot determine next year is 2020
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
3,231
I suggest use normal format date: dd/mm/yyyy or in US style: mm/dd/yyyy without custom formatting like: Sat 1 Feb
 

Kerryx

Board Regular
Joined
May 6, 2016
Messages
78
Wish I could but data being pulled from a website so gotta work with what I got
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
3,231
data being pulled from a website
you need to convert data to be a proper data (date)
if on website dates are as dates it's ok, but if as text you should convert it manually

btw. Sat 11 Jan is not a date, simply this is a text that pretends to be a date
 
Last edited:

Forum statistics

Threads
1,077,896
Messages
5,337,057
Members
399,120
Latest member
Sravankumar

Some videos you may like

This Week's Hot Topics

Top