formula to sort by <= Today's date

[#1]

I have a straight table with a list of production orders and start dates.  I want to enter a formula to only see the start dates <= Today's date.  What is that formula and where exactly do I enter it? I have tried many variations but apparently have not found the correct formula yet.  Thanks!

[alexandros17]

When you compare dates these must be expressed in the same format, to bypass this requirement transform into numbers:

Num(MyDate) <= Num(Today())

let me know

[#3]

I do have a master calendar and DATE is my production order start date. Can I write DATE<=(Today()) would I enter in the expression box under the sort function or do I enter it in the expressions box. Obviously, DATE<=(Today()) must not be right because it gives me – as an expression and does not sort out the future dates in the sort expression box.

Kimberly Glidewell

E-Z-GO/Textron

Systems Analyst

Phone: 706-560-6091

Fax: 706-826-1210

[ashfaq_haseeb]

Hi,

In sort tab sort by expression and use below expression.

=day(YourDateField)

Regards

ASHFAQ

[#5]

If I enter that I still get dates that are in the future. I want to exclude future dates and only see past due or today’s dates.

Kimberly Glidewell

E-Z-GO/Textron

Systems Analyst

Phone: 706-560-6091

Fax: 706-826-1210

[ashfaq_haseeb]

Hi,

If possible can you share a sample file with expected output.

Regards

ASHFAQ

[Anonymous]

Kimberley

You will need to use the start dates <= Today's date within Set Analysis for your expression.

If you are unsure of the syntax then post your expression.