This content has been marked as final. Show 7 replies
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.
Date(Floor(ClosingDatePear)) as ClosingDatePear
Where Intranet_Only = 'Yes'
and Status_Requisition = 'Open'
Order by Status_Requisition;
Many thanks in advance for your help