Datetime in Resident Table won't convert to Date

[timsaddler]

Hello all

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

[jpenuliar]

Hi Tim,

Have you tried:

Date(Floor(ClosingDatePear),'DD/MM/YYYY') as ClosingDatePear,

[timsaddler]

Hi Jonathan

Yes i have tried that and it doesn't work for some reason.

[anbu1984]

What is set in the DateFormat variable? Do you have time in DateFormat variable?

SET DateFormat='M/D/YYYY';

[fvelascog72]

Try:

Left(ClosingDatePear),10) as ClosingDatePear,

[jpenuliar]

Maybe a :

Date(Floor(Timestamp

[martyn_birzys]

I just use this

Date(ClosingDatePear) as ClosingDatePear,

[timsaddler]

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 !