Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Team,
Has anyone gotten the chance to review the above script logic?
Thanks,
Irshad Ahmad