Skip to main content

General discussion

ODBC Import - Date Filter

Hi there,
Does anyone know how data can be imported using the ODBC connection feature in IDEA with applying a filter on a date field?  I have tried numerous formats for dates ('YYYY-MM-DD') and ('MM/DD/YYYY'), using both a live Oracle database and Excel practice files but nothing seems to work.  I can filter on character and on numeric fields with no problems, but date fields do not seem to work.  
Does anyone know how to fix this or is this a bug in IDEA with the ODBC connection?
Any help would be appreciated!
Mike

Internal Auditors

How many people here are internal auditors?  I'd love some ideas on ways to use IDEA in all sorts of areas.  I work for a tribal govt in Internal Audit and am also a CFE.  I use IDEA in a variety of ways usually for special projects like the new Covid 19 payroll, and determining turnover but would love to develop some weekly/monthly recurring analysis using the data I can get from our accounting system and the HR system.  Eventually I'd like to get access to the gaming data.    How many have the IDEA certifications?  I've been looking at jobs and a lot of

How to make a join with scripting - Criteria problem

Hi!!
While I was studying, i tried to make a join between 2 databases that I already have both IMD files.
I have a criteria inside IDEA, but I can't use the same criteria using IdeaScripting..
Would you mind helping me to fix it? Please!
 
Set db = Client.OpenDatabase("SR3_STEP1.IMD")
Set task = db.JoinDatabase
task.FileToJoin "SR3_STEP2.IMD"
task.IncludeAllPFields
task.AddSFieldToInc "ID_SR"

Complete Guide to Auditing with Data Analytics Tools

I have this and it breaks down various areas to audit (AP, AR, GL, etc) and gives a list of things to do but no examples of how to do them using IDEA?  Is there somewhere that provides this information?  Is there a script out there or in the Analysis area?  Thanks in advance.

Webinar on Custom Functions

I did a webinar for SAMA on custom functions.  It is not available on YouTube if you want to see it.  It is about 45 minutes long, first 30 minutes is my presentation and the rest is questions.  I go through three items, one is a simple custom function to show how they can be created, two is showing how you can take a fairly difficult equation in the Equation Editor and make it more readable as a custom function and third is creating custom functions that aren't available in the Equation Editor.