链接表中的日期转换 [英] Date conversion in linked table

问题描述

我有两个链接的csv表，其中包含几个日期时间字段 - 所有格式都相同。 

Hi, I have two linked csv tables that includes several datetime fields - all the same format. 

此链接数据已经持续数月，并且由于某种原因截至昨天，正在返回#Num！所有日期字段的错误。 

This linked data has been working perfectly for months, and for some reason as of yesterday, is returning a #Num! error for all of the date fields. 

链接规范没有变化，当我导入而不是直接链接相同的csv数据文件时，数据导入准确。 我查看了链接规范，它确实应用了日期/时间格式结构。  I
创建链接规范的第二个版本以确保，并且产生相同的错误。

There had been no changes to the link specification, and when I import rather than link the same csv data file directly, the data imports accurately.  I've reviewed the link spec and it does accurately apply date / time formatting structure.  I created a second version of the link spec to be sure, and the same error results.

我是唯一有权访问此应用程序的人，所以我可以保证没有其他人在我不知情的情况下进行了更改。

I am the only person with access to this application, so I can guarantee that nobody else has made changes without my knowledge.

此文件是我们每月佣金计算的输入，因此非常重要的数据。

This file is an input to our monthly commissions calculations, so pretty critical data.

推荐答案

好吧，无视。 在昨天和今天之间花了几个小时，重新安排，刷新，重新检查，重做...我发表评论以获得帮助/反馈，并且不知怎的，这次刷新工作。 所以，不确定如何（grrr ...）但问题解决了。 
干杯！

Well, disregard.  After spending hours between yesterday and today, relinking, refreshing, rechecking, redoing... I post a comment for help / feedback, and somehow THIS time, the refresh worked.  So, not sure how (grrr...) but problem solved.  Cheers!

这篇关于链接表中的日期转换的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！