Forum Discussion
Johan-MTM
Helper III
3 years agoWhole number to date
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" instea...
- 3 years ago
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
Helper III
3 years agoThank 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
Helper III
3 years agoI needed to go inte Edit query and then do the solution from the video - wkred like a charm!
Thanks for the help!