topic Re: Comparing Dates in QlikView

Comparing Dates

pandreozzi — Fri, 16 Jun 2017 14:39:16 GMT

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.

Re: Comparing Dates

ahaahaaha — Sat, 17 Jun 2017 09:52:54 GMT

Hi,

May be like as in attached file.

Regards,

Andrey

Re: Comparing Dates

pandreozzi — Mon, 19 Jun 2017 12:18:24 GMT

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.

Re: Comparing Dates

pandreozzi — Mon, 19 Jun 2017 12:19:13 GMT

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

Re: Comparing Dates

pandreozzi — Mon, 19 Jun 2017 18:41:54 GMT

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

Re: Comparing Dates

pandreozzi — Tue, 20 Jun 2017 11:52:20 GMT

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?