Comparing Dates

[pandreozzi]

I have a project where I need to compare a billing end date with today's date -1 day.

My table box contains an end date field called BILLING_END and I added a button to the sheet called "Items Not Billing"

When I select the button I would like the table box to show all information that has an end date prior to the date the application was accessed or use the system date either is ok.

Example:

The end date is in the following format: 31-DEC-99

Please if you can provide an example that would be great.

[ahaahaaha]

Hi,

May be like as in attached file.

Regards,

Andrey

[pandreozzi]

Hi Andrey and good day. I did look at your attachment and cannot see what is happening. When I chose a date from the date object I cannot see the results.

[pandreozzi]

Also. I have a table box that pulls in my information from the DB and a button but I like the calendar object also.

[pandreozzi]

Andrey. I may of gotten this to work with your logic. I removed the table box and replaced it with a Chart. I added parts of your script into my expression statement and had to modify the date in the load statement as this was being read as a string.

Date(Date#("Your_Field", 'DD-MMM-YY'),'MM/DD/YYYY') AS Your_Table,

I will continue testing and appreciate your input.

Paul

[pandreozzi]

One last question. I have a date in my DB that is as follows.

01-DEC-99

The year 99 is being converted to 1999 but I know that it should be 2099.

Is there a way to force this to the year 2099 in some function or variable?