how to find days of due date like <1days,<2days by using due date field?

[krishna789]

hi

i have due date field  .if i give drop down list  < 1 days,<2day,<5day  . I should get   tables related to due date .my question is how find

<1 day ,<2 day  from due date .pls share any set analysis .

[sunny_talwar]

Get the days of due date by comparing due date to what? Today?

[Clever_Anjos]

You can use a As-Of table with proprer flags

The As-Of Table

[krishna789]

actually i have due date field  .i should find less than one day how many  due are there similarly less than 2 days,less than 5 day .

we will write like load editor

load

max(duedate)  as less than1

max(duedate)-2   as less than2.

i am not sure above syntax   .  sorry  for poor communication 

[krishna789]

compare with today

[sunny_talwar · Accepted solution]

Why do you need set analysis for this? You need a filter, right? Create a new field in the script like this may be

If(Today() - DueDate < 1, '< 1 days',

     If(Today() - DueDate < 2, '< 2 days',

          If(Today() - DueDate < 5, '< 5 days'))) as DueDays

[pradosh_thakur]

hi

Try this. and please check the date format in your app before use to get the correct data

1: create inline table with one column

load *inline

[

  diff

     1

     2

     5

];

2 create a list box and use expression instead of field

=if(diff=1,'<1 day',if(diff=2,'<2days',if(diff=5,'<5 days')))  ->> filter

3: another list box with expression

=If(DueDate-Today()<= GetFieldSelections(diff), DueDate,

     If(DueDate-Today()<= GetFieldSelections(diff),DueDate,

          If(DueDate-Today()<=GetFieldSelections(diff),DueDate,null())))

let me know if you need a qvw

regards

Pradosh

[pradosh_thakur]

if today() used in the script is it needed to reloaded daily for updation or it will be done automatically?

[sunny_talwar]

Daily reload will be needed