Discussion Board for collaboration on QlikView Scripting.
Silly issue this but i have extracted data from sql server into qlikview
I re-extract this from the resident table but the floor function doesn't work.
I need to show just the date - without the time.
Load "Ref", Requisition, "Region_Web_Details", "Status_Requisition", "Start_Date_Requisition", "End_Date_Requisition", "Application_Closing_Date_Requisition", Date(Floor(ClosingDatePear)) as ClosingDatePear "Publish_On_Web", "Intranet_Only" Resident Vacancies Where Intranet_Only = 'Yes' and Status_Requisition = 'Open' Order by Status_Requisition;
Many thanks in advance for your help
Have you tried:
Date(Floor(ClosingDatePear),'DD/MM/YYYY') as ClosingDatePear,
Yes i have tried that and it doesn't work for some reason.
What is set in the DateFormat variable? Do you have time in DateFormat variable?
Left(ClosingDatePear),10) as ClosingDatePear,
Maybe a :
I just use this
Date(ClosingDatePear) as ClosingDatePear,
Hi - I asked an impossible question.
The reason it dosen't work is because i concatenated a row of text to provide a google filter.
Hence Qlikview is confused by whether the column is text or date !
I had to go back to sql to sort it.
Thanks for all the help though !