Skip to main content

General discussion

Converting Character to Date Format (MM/YYYY)

I am trying to convert from Character to Date format that doesn't include the "day" information, only month and year. I have tried both changing the original column to Date and it doesn't accept the "MM/YYYY" date mask (error message: Invalid Date Mask)
I have also tried to append a new Virtual Date column using the equation @ctod(Field Name, "MM/YYYY") but instead of dates in the column, it shows "Error" in red font in each line under that column.
Thanks for any and all help!

Append Field from my variable

Hello, how are you? 
I need help, I have a variable as a string and I can't insert the value of the variable into the new column. Is it possible to do this?
For example: 
Dim instancia As String
Set db = Client.OpenDatabase("Parámetros de contraseña.IMD")
Set task = db.TableManagement
Set field = db.TableDef.NewField
field.Name = "INSTANCIA"
field.Description = ""
field.Type = WI_VIRT_CHAR
field.Equation = instancia 'my error is here, I don't know how to add the content of my variable as a value of the fields.

Create a "group key" for duplicate transactions

TYIA -
I'm working on a duplicate transaction analysis. I want to create a field where each duplicate "group" has a unique number. Any ideas?
Example of what I'm hoping for:
RecNo Vendor Date Amount **Group Key**
1             XYZ      4/20   $20        1
2             XYZ      4/20   $20        1

IDEA Script or Function where the result of one task is used in the next task

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.
 

Use dates within an equation field

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.
 

Printing Loop

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.