Loading data from a specific date onwards

[DS14]

I have the date field Billing Date in sales table and I have to load data from 1-07-2017.

I tried by using where  Billing Date >= '1-07-2017' and also  Date(Billing Date,'DD-MM-YYYY') >= '1-07-2017'.

But its not working.

BillingDate
02-04-2016
03-04-2016
04-04-2016
05-04-2016
06-04-2017
07-04-2017
08-04-2018
09-04-2018
10-01-2019

Please guide how to achieve this.

Thanks in advance.

[pradosh_thakur]

Hi

Plese change this in your script if your BillinDate is in string format first
date(Date#(BillingDate,'DD-MM-YYYY')) AS BillingDate

then apply where condition to filter the data as the date can be used else where too.

[pradosh_thakur]

Again

where Date#(Billing Date,'DD-MM-YYYY') >= Date#(Billing Date,'1-07-2017') will even do even if you dont change the format in the first place.

[tresesco]

This is probably date format issue. You need to correct few things and try like:

where Date#(BillingDate,'DD-MM-YYYY') >= Date#('1-07-2017','DD-MM-YYYY') 

[DS14 · Accepted solution]

I solved it. It was a format issue due to which I was struggling.
The solution is
where Date(BillingDate,'DD/MM/YYYY') >= '1/07/2017'

Thanks everyone for quick res-ponce and support.