General discussion
Calculating Days between Dates
Forums
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.
- Read more about Calculating Days between Dates
- 3 comments
- Log in or register to post comments
Use dates within an equation field
Forums
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.
- Read more about Use dates within an equation field
- 2 comments
- Log in or register to post comments
Expanding an Object before Exporting it
Forums
- Read more about Expanding an Object before Exporting it
- 2 comments
- Log in or register to post comments
Printing Loop
Forums
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.
- Read more about Printing Loop
- 1 comment
- Log in or register to post comments
Summarizing by date
Forums
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.
- Read more about Summarizing by date
- 1 comment
- Log in or register to post comments
Search For Text & Categorise
Forums
Hi,
Apologies if this has been asked before, I couldn't find it.
- Read more about Search For Text & Categorise
- 4 comments
- Log in or register to post comments
Date Range Match
Forums
Trying to match a specific date to a date range. Is this possible?
- Read more about Date Range Match
- 2 comments
- Log in or register to post comments
Is it posible to change the execution time for a script?
Forums
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.
Report Reader and Adobe Pro DC
Forums
At my office we recently switched from Adobe 9 (I think) to Adobe Pro DC. We are finding some issues when we now import PDFs into Report Reader. For example Report Reader isn't reading the PDFs as clearly as before. It may turn the number 0 into the letter o. Usually we add a page number to the PDF, so if the Report Reader misses something, we can easily see where the problem is. However, adding the page number now seems to hinder from reading the PDF clearly. We have IDEA version 10. Would version 11 fix this? Or is anyone else running into a similar problem?
- Read more about Report Reader and Adobe Pro DC
- 5 comments
- Log in or register to post comments
IDEA 10 and IDEA 11 database compatibility
Forums
Would anyone know if IDEA 10 can open and work with databases created in IDEA 11? I think usually in the past whenever a newer version of IDEA is released the software is backwards compatible but not frontwards compatible.
- Read more about IDEA 10 and IDEA 11 database compatibility
- 1 comment
- Log in or register to post comments