Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Something unusual is happening to me. I always link in the same way the dates of any table with my Calendar and I have any problem, until now.
I use the Date() function and the dates are like this: 'DD-MM-YYYY'
DATE(Info_TimeStamp) as %Date
I have a table Calendar and my %Date field has the same format than the other %Date of my fact table and the link appears on the diagram.
Is like there were two different fileds %Date, one with only one date by day and other with repeated dates by day because in one day there are a few operations but in other qvw always appears one date by day.
Now, if I select a month, the field %Date looks fine but if I select a %Date of one table, there is no selection in my calendar fileds, no month, no year, no day... and if I do any selection and I review my field %Date, there are repetead dates.
I have no idea what is happening, in other qvw this is working perfectly so if anyone has any idea I will thank you.
Regards,
José
Date() is a formatting function that only controls the display value of the field. So your %Date field is still a timestamp. Try
DATE(floor(Info_TimeStamp)) as %Date
-Rob
Can you upload your qvw?
Date() is a formatting function that only controls the display value of the field. So your %Date field is still a timestamp. Try
DATE(floor(Info_TimeStamp)) as %Date
-Rob
Thank you Rob,
I´m glad to know what is the origin of the problem.
Regards
-José