Custom Function Request

Hi Brian
I trust that you are well? I am trying to calculate the number of days between two dates (inclusive). I have used @age and this works fine. However is there a way to exclude Saturday and Sunday from the calculation? Also I need to exclude certain public holidays as well. Is this possible through a custom script or function? I would like to input the public hoilday dates or I can even code them in. I am using IDEA v8.5.
Thank you in advance!
Regards
Aveen
 
 

Hi All
I have just imported 2000 files into IDEA. Is there an easier way to append all at one go? Is there possibility of writing a custom script? I am using IDEA 8.5.
Thank you in advance.
Regards
Aveen
 
 

Hi Brian
It has been a while. I downloaded the videos on the credit card fraud using caseware monitor and I was really impressed. I need some help with a custom script again please.
I need to compare multiple databases to determine if data has moved from 1 database to the next. In each of the databases the unique identifier / key is a purchase order number (po number).The comparison is for a typical 5 way match i.e. Purchase Requisition To Purchase Order To Goods Received Note To Invoice To Payment.

Hi Brian
I am struggling with converting a piece of data. I have attached a spreadsheet with a few records. I am trying to change the data in the Column "Open time" Currently it represents 12:00A. This time is in the morning and I need to convert it to 12:00:00. I am not concerned with the seconds so it can always read 00.
For the data in row 8 i.e. "04:21P" it is in the afternoon and must read 16:21:00. Again the seconds are not important so they will always be 00. Is the there a way to convert in IDEA?
Thank you in advance!
Aveen
 

Hi Brian
I trust that you are well? I have created an IDEA v8.5 script to test the validity of a RSA Identification Number which is 13 digit number basedon a specific algorithm.
My script runs fine, and outputs the correct result. However I keep getting the following error:
Error on line 215 - A valid field name is required.
I have attached the Script File and sum data. Can you maybe check what's wrong with my script please.
Thank you in advance
Regards
Aveen

Hi There
I am looking for a custom function / script that will allow me to export multiple IDEA databases into excel without exporting each one individually. I am using IDEA 8.5.
Thank you in advance!
Aveen
 

Hi Brian
I have imported multiple SAP outputs. I am finding that the column headings are in German, but I know what each if them mean. I was wondering is there a script of a way to rename each of the fields, if field manipulation prevents change of column names.
Thank you
Regards
Aveen
 
 
 

Hi Brian
I have another request. I usually work with data that contains numerous dates which are all in character format. I generally use the @cTod and this always works. Recently I have received with data with the date formats as follows:
1 February 2013
2003 February 1
1 Mar 2013
Mar 1, 2013 
Is is possible to write a script that will change any data like above to the format YYYYMMDD.
Thank you
Regards
Aveen
 
 

Hi Brian
I am currently using IDEA 8.5. I have 1000 excel files (.xlsx) each named differently with different sheet names (1 sheet per workbook). I have all these excel files stored in one folder.
I am looking for a script that will allow me to import all at one go as opposed to importing them one by one.
Thank you in advance.
Regards
Aveen
 
 

Hi There
I need some assistance to write an IDEAScript to identify all transactions that occur on South African Public holidays. The date of the holiday never changes. Ideally the script must allow the user to select the file to test and then column that holds the date. Then the script must run and extract all those records that were processed on the following dates:
 
1 January
21 March
29 March
1 April
27 April
1 May
16 June
17 June
9 August
24 September
16 December
25 December