Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a calendar object that shows the end date of a search criteria. However it doesn't display the date I have selected.
If my start date is 01/01/2012 and my end date is 01/02/2012, only up to the 31/01/2012 is brought back. The reason is because the field I am using is a TimeStap Format, therefore my date shows 01/02/2012 11:00:00, however it were 01/02/2012 00:00:00 it would show.
I have no idea how to amend my script so that it picks up the date regardless of the time stamp.
Please see attached a copy of the Qlikview File.
Regards,
Jon Ditchfield
Hi,
When you use the function 'Date' format without specifying the number, she picks up the operating system. Try to format the date as:
=Date((min({1}Log_Date_JD)),'DD/MM/YYYY')
Rebeca
Hi, Unfortunately this didnt work. I should have a date in the log date section of 09/02/2011, but it doesn't show even though I have added it in the end date section.
Hi,
Use below expression to create Date.
Date
(floor([logdate])) as Log_Date_JD
Regards,
Kaushik Solanki
Hi Kaushik,
I have tried adding the expression into my load script, which does pull through just the date, however I am still getting the issue where my calendar object is not pulling the required date.
E.G,
1) Set a date range from 01/01/2011 to 09/02/2011 - The last date that shows in the Straight Table is 24/01/2011
2) However if I set a date range from 01/01/2011 to 10/02/2011 - The last date that shows in the Straight Table is 09/02/2011.
The last date in the Straight Table that shows 09/02/2011 should show when I set my end date to 09/02/2011, but it doesnt.
Regards,
Jon Ditchfield