General discussion

I kindly need assistance with an IDEA script or function where the end result in task 1 is used in task 2; Balance in Period 0 is used to get Balance in Period 1, Balance in Period 1 is used to get Balance in Period 2, Balance in Period 2 is used to get Balance in Period 3, ...
 
I am preparing a loan schedule based on amortization.
 

Hi, hoping to get some help here on this.
Any way to replace text in existing records of a table? e.g. to replace the values of a cell = values of a cell in another column. 
Thanks!

Hi! I need to calculate the days between the field date and 3/31/2019. I am trying to do this in Equation Editor and cannot use the @Age function. I entered in the following: "20190331" - INVOICE_DATE and the equation error "mismatch field type" is showing up. Any help would be appreciated. 

Hi Bryant,
I wanted to asked about a problem I 'm having with dates. Every time I try to type manually a date withing an equation field, it raise an error "non-matching field type". I was reading in one of your post that withing an ecuation I need to type dates in the format YYYYMMDD but even doing this it doesn't work.
 

Hello from Germany,
my question, I hope it is in the right Forum here, is as follows:
I have a number of databases that I want to print. I have a script for the first one of them (shown below) and now I want to do a loop, that prints all the data from 1 to 46 without changing the skript for every database.
 
Sub Main
Call PrintDatabase() ´Datei anhängen1.IMD
End Sub
Function PrintDatabase
Set db=Client.OpenDatabase("Dateien anhängen1.IMD")
db.Print
End Function
 
Thanks for your help.
 

Hello,
I'm trying to make a summarize to obtain the minimum date of certain groups, but IDEA only allow me to do it by numeric fields. I would like to know is there is a way in wich I can do that. I'm thinking of converting that field to numeric, doing the summaize, and then rollback the convertion, but I'm not sure if there is a function in IDEA for that.

Hi,
Apologies if this has been asked before, I couldn't find it.

Trying to match a specific date to a date range. Is this possible?

Hello Everyone,
 
What I'm trying to do is running an IdeaScript wich calls a python program, that program makes a transformation of the data and then create a csv which is taken by IDEA again. But the problem I have is that IDEA execute the script too fast, so the csv is not generated on time to IDEA. That is the reason why I want to delay the time of execution to give python some time to generate the file that IDEA requests.