General discussion

Hi Brian and greetings from Ireland,
I've a quick question for you.
My version of IDEA keeps defaulting to US keyboard, regardless of what I've set in windows.
This is driving me mad esp. as the " and @ characters are swapped !!
I can't seem to find a setting to change it to a non-US english keyboard layout.
Any help would be much appreciated.
Thanks,
Phil
 

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!

Hello Everyone,
I'm trying to obtain a decimal number inserted by an input box, but the problem is that IDEA shrinks the number, so if I type 1.9 and store it in a variable, the value of the variable is 1 instead of 1.9. Can anyone help me with this, please?

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.

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

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.