Hi,
I have a csv, the format for the date follows all the guidelines yet it refuses to let me add it to any date type fields. I have 46 blog posts which i need to import and have their original publish dates. 
I have checked all the help docs so am a little lost.
I can assign the other fields ok.
Thanks,
Josh
cells formatted to:
OMG, I figured it out. You have to switch it to American format 
haha
In future iād love support for english date formats
Thanks!
Josh
To ISO format 
Which isnāt american as USA uses AM/PM dates.
Any format from here : Date and Time Formats
But in that form : YYYY-MM-DDThh:mm:ss.sTZD
The ZD is for timezone so if you have set your site as GMT+1 (= UTC+1) for ex, youāll finish your date like this :
2017-11-08T13:00+01:00
Wjhat happens is Webfow is going to ingest your date and convert it to UTC. Then it will convert the UTC stored date into your site date, using your timezone setting. Then in the Designer, in the CMS database and on publish, it will display the computed date in the american AM/PM format.
Edit: if you need another format I made this 
http://pardon-my-french.webflow.io/
Thanks for the more detailed reply @vincent - thatās good to know re time setting!
Fortunately our blog will just be by day rather than time.
I got it to import simply with this format in the cells:
as this didnāt work:
Thanks again!
With the slashes? Iām really glad that it worked but Iām surprised it did
Yep, uploaded the csv exactly like in that pic.
Haha Iām glad too!
Can you screenshot how it is in the CMS database now? Wht time did it add to the date? The time of import?
Because when manually entering a date in the CMS, youāre not allowed not to add a time.
Thanks, itās just for satisfying my curiosity
Curiosity killed the cat, so be careful buddy!
But happy to help anytime
hey again dude. On a slight separate issue:
Why is it showing august on the block but November (correct) in sidepanel? If i go into the article it shows correctly nov 22nd but randomly august here 
Both pull data from same place but either way, its showing one thing on sidepanel and diff in editor/live on site
November 22nd is today. Often, when displaying example of dates and time, Webflow is using the actual date and time.
Fooled by a coincidence! I feel very stupid and will now delete my account
It happened to me more than once! Sometimes I"m working with data that are indeed today, andā¦ Iām like WTF is the time not correct!
Letās classify this one in āHappens to all of usā
Haha sounds good to me!
Hi,
Thanks for the info on the appropriate Date format M-D-Y (not so natural for non-american users)
Iāve seen something quite weird happen when wanting to import my CSV data :
Webflow seems to remove a day to all datesā¦ which is quite surprisingā¦
Any idea why ?
If itās a timestamp thing, I unfortunately canāt provide the UTC time for publishing dateā¦ which means Iāll probably have to accept the fact that my 799 article publishing dates will be 1 day wrong 
If you have any suggestions Iāll be glad to try them out
wow i have exactly the same issue as you but no solutions just yet
I havenāt tested this lately, but make sure your site settings are for the correct timezone you want, it will very likely affect the import, particularly if your date data does not specify a timezone.
In some of the posts Iām reading above, Iād assume the siteās timezone was incorrect.
One other tip- even if Webflow allows you to import dates into its default 3 date fields, just donāt. Make your own date field instead. The published date field is often incorrectly misunderstood as ādate first publishedā, and itās not- itās ādate last publishedā which will totally confuse your blog.
