Whole number to date

[Johan-MTM]

Hi,

The column "souce_published" contain years (year when book are published) but with data type and format as "whole number".

But if i change date type to "date" the "souce_published" instead show dates in june/july 1905.

And if i also change "format" to years (yyyy) it only show the year 1905.

Any idea why this is?

[Padycosmos · Accepted solution]

This video, though intended for another topic, illustrates conversion from Number to Date

https://www.youtube.com/watch?v=0sci44xnto0&list=PLApPcvU5-R24K3mbxORV7T3ckVLfDjmHF&index=20

[Johan-MTM]

Thank you for your reply. I tried the solution in the video but I get an error message after I convert to text and then try to convert again to Date:

[Johan-MTM]

I needed to go inte Edit query and then do the solution from the video - wkred like a charm!

Thanks for the help!

[Greg_Deckler]

@Johan-MTM It is because a Date is a decimal number and the integer portion is the number of days since December 30th, 1990. So, you would want to do something like DATE([source published],1,1)