• Home
  • Forums
  • FME Form
  • Transformers
  • HI all, How do I convert a date time attribute of this example "44821.76657" to DD-MM-YYY HH-MM-SS? using the Attribute manager. Loading the same data in Excel I simply specify it as Date and it gives 17-09-2022 18:23:52.
Solved

HI all, How do I convert a date time attribute of this example "44821.76657" to DD-MM-YYY HH-MM-SS? using the Attribute manager. Loading the same data in Excel I simply specify it as Date and it gives 17-09-2022 18:23:52.

  • 8 November 2022
  • 3 replies
  • 2 views
E

I was told the data  "44821.76657" is the elapsed days and time since "1 Jan 1900"

icon

Best answer by geomancer 8 November 2022, 13:11

View original

3 replies

david_r
Rank
Userlevel 4

There are a couple of solutions here: https://community.safe.com/s/question/0D54Q000080hNiUSAU/converting-floating-point-date-based-on-1900-date-system

geomancer
Rank
Userlevel 4
Badge +36

This one had me stumped for a while, as my results kept being one day off. But it turns out all Excel versions have a deliberate bug: 1900 is considered to be a leap year(!). Apparently this was done for better compatibility with the once famous Lotus 1-2-3.

Of course all Excel functions niftily work around this real Year 1900 Bug! For more information see here.

Also bear in mind that 1-1-1900 is day 1 (not 0).

Excel_Day_NumberPlease note: This solution gives a wrong date for all 59 days in januari and februari 1900. I hope this is not a problem ;-)

E

HI all, thanks for the feed back, I was able to get it solved using a combination of both of your response.

Reply


Community Stats

28,670
Posts
109,367
Replies
36,531
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.