Counting orders created before today.

[Lobo77]

Hi all, hoping you can help. Looking to count orders that have been created before today,s date.  I do need it a s a set analysis. I do not have access to load script or creating a variable. I know there should be a a simple solution , but cant seem to get anything but "0" as a result with the solutions below.

The two fields I have are 'order_id' , and 'Order Creation date'. 

The format of the creation date is as dd-mm-yyyy. 

Have tried many of the solutions from other posts with similar questions, and only ever get '0' , when we have many orders 

Thanks in advance

Count({<[Order Creation Date]= {"=Order Creation Date >= Now()"}>} distinct [ORDER_ID])

Count({$<[Order Creation Date] = {">=$(=Date(Today(), 'DD-MM-YYYY'))"}>} distinct [ORDER_ID])

Count({$<[Order Creation Date] = {">=$(=(Now()))"}>} ORDER_ID)

Count({$<[Order Creation Date]={"=Date(Floor[Order Creation Date]) >= Today()"}>}[ORDER_ID])
Count({$<[Order Creation Date] = {">=$(=Date(Today(),'DD-MM-YYYY'))"}>} [ORDER_ID])

[Yousef_Amarneh]

try the below

Count({$<[Order Creation Date] = {">=$(=Num(Date(Today(),'DD-MM-YYYY')))"}>} [ORDER_ID])

[Lobo77]

Thanks Yousef for the suggestion.

Unfortunately  getting same result , "0".

Its seems odd , if I do an simple if statement , it works , but I cant use an if  statement in this situation.

Thanks again