where condition with date

[upaliwije]

I have a QVD data file where one date field is PERIOD_TO

I want to load data restricting  where PERIOD_TO<='31-08-2014'

But it is giving error message. Pls help me to modify the where condition

[maxgro]

Where

PERIOD_TO <= makedate(2014,8,31)

Where

PERIOD_TO >= '31/08/2016'          // or MM/DD/YYYY

[jer_2011]

Hello

another example

Where PERIOD_TO <= date('31/08/2014','DD/MM/YYYY')

OR

Where date(PERIOD_TO,'DD/MM/YYYY') <= date('31/08/2014','DD/MM/YYYY')