Extraction Based on Date

Primary tabs


A small script that allows you to do an extraction based on a date.


This script allows you to do an extraction based on a date.  You select the file, the date field and then select the date from a calendar.  You also can decide on the type of extract, do you only want equal dates, earlier dates, later date, the script gives you the option.


engdushime's picture

Dear Brian I am Jean Claude Dushime From Rwanda a Data analyst and IS auditor in KPMG International , I am new  on platform but your Job is really amazing. I have One question Can you help me to details the Key test that can be performed arount the follwoing area in Bank Loans and advance ,fees and commissions,interest income ,interest expenses ,Testing of Journal Entries, etc

Brian Element's picture

I am glad you are enjoying the site.  Unfortunately I don't work in the banking area so I really don't have much in the way of advice.  CaseWare has a document that might help you out, so you should check it out as it can give you some ideas of what can be done.   https://idea.caseware.com/analytics-for-external-auditors/

Hello , very nice job .. 
What can i do on the script to define de date choice between 2000 and 2021 ? in place of 2016 to 2020 ?