Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Community,
I have been struggling with this connecting my data and my calender for a few weeks now.
What makes the calender take only parts of the data instead of all of the dates?
What do I need to do in my script in order for these tables to align with each other?
Please help!
The Calender object on the QVW below is associated with [Create Date]
[Create Date] is associated with the list of request numbers, names for that request, and another date.
If you choose a calender selection (2015), it will pull up dates associated, but will not find other information.
If you choose a Request ID, it will align with the user name and dates, but nothing on the calender object.
try this
floor function remove the time part of the date and date function format the date
LOAD
*,
date(floor(date_time)) as DateWithoutTime
;
SQL SELECT
*,
dat_data as date_time // dat_data is a datetime
FROM asqlservertable
;
do you need the time in the create date?
the problem is the datetime ARRequestList and MasterCalendar doesn't match
why doesn't match?
because you calculate the min Create Date from ARRequestList 4/12/2006 7:02:55 AM
and generate the calendar from this, all days with the same time 7:02:55 but in your ARRequestList table the time is different and the association often doesn't work
I suggest to only use the date part in your Create Date (if possible with your requirement)
Hi Massimo,
I do not need the time in create date.
I've been researching more on SQL server code and trying to figure out how to use only the date.
May I ask for an example or a function that could isolate the date regardless of time?
Thanks in advance!
try this
floor function remove the time part of the date and date function format the date
LOAD
*,
date(floor(date_time)) as DateWithoutTime
;
SQL SELECT
*,
dat_data as date_time // dat_data is a datetime
FROM asqlservertable
;
Thanks! This did the trick!