Export the data after 2 days of 21 Bill group

[iahmadmca1]

Hi Team,

Just want to ask small doubt while running the script conditionally.

I have attached the sample excel data based on data I need to execute this script tab when after 2 days of 21 End bill group.

As for example:

we have last  BG 21 and getting the end date of 1/22/2018, It means this script should be executed on after two days(1/24/2018) of the 21 end bill group.

I am using the below script to achieve this issue.but it not getting satisfied.please add if anything wrong in my existing script.

if(Date(today())=date(End+2) and BG ='21') THEN

Dataracker:

LOAD [Bill period],

    BG,

    Start,

    End

      FROM

(ooxml, embedded labels, table is Sheet1);

ENDIF

Please let me know in case of any clarification.

Note: The BG 21 is the last bill for each month.

Thanks,

Irshad Ahmad

[iahmadmca1]

Hi Team,

Has anyone gotten the chance to review the above script logic?

Thanks,

Irshad Ahmad