Populate data based on date

[Anonymous]

Hi All,

I have a requirement where in we need to populate Names based on the below condition.

We have a date called expire date set against each name and we need to populate the data in a table format where in it shows those names which has expire date coming up in 90 days.

The data that are there in the application and should be shown in the table are:

Name

Region

Expire date,

Amount

Kindly let me know if you need more information regarding this

Thanks in advance

Anupama Jagan

[vishsaggi]

Can you provide some sample data and expected output please ?

Try something like

Table:

LOAD *,

     IF(ExpireDate = Date(Today() + 90, 'MM/DD/YYYY'), 'Expiring in 90', 'InDate') AS ExpiredFlag;

LOAD * Inline [

Group,  Product,    Amount, ExpireDate

a, Jam,     10, 7/11/2017

a, chinese,     20, 7/11/2017

c, Frozen,        30,4/12/2017

c, Pickle,   40, 7/11/2017

d, Tea,         50,4/12/2017

d, kora,          60,12/12/2017

];

[Anonymous]

Hi Vishwarath,

I have attached the sample data in the original post

The output should show all the Qnums which has expiration date in next 90 days.

The table should contain

QNums, PNums

In your example it shows all products which expires exactly in 90 days right. My requirement is it should display only those QNums which will be expired in next 90days from current date.

Kindly let me know if you need more information regarding this.

Thanks,

Anupama Jagan

[vishsaggi]

Check attached?

[#5]

Hi,

Try to create a new date in script witch is your expire date + 90 and then you can use set analysis for the rest.

See the sample attached.

Regards,