Conflict of date format combined with the holiday-effect...
I am facing an issue concerning date formats:
- Just before I went on holiday for three weeks, I set up a "historical qvd" that stores one value per day, along with the date, out of a database table that has values only for the present day.
- For some reason, the date is stored as a numerical value in that table - I have myself made sure it is
<=> My dilemma right now is that I don't quite remember what was the reason - there must have been a good one - that I stored the date in numeric form: That way, I cannot link that table to my master_calendar and the diagram does not work.
Can anyone help me over the default of my memory, please?
I can repair it by including a DATE() fct. in that LOAD statement - but I'm not sure of this because I don't remember why I chose to do it the other way in the first place.