General discussion

Hello all,
Is there any quick method of getting the name of the month (using the Date field in the datasource) rather than writing a long formula with @if(@month(DATE) =1, "January" ... etc.
Regards
 

Hi,
I'm currently creating a script where by I am extracting some key statistics for individual locations for my company.  This information is then exported to an Excel Spreadsheet template populated with company norms (created by a separate macro) in order to provide a comparison. 
 

Hi,
I normally use vscript (macros) and I wanted to create a script to pick up the value on fields which are shaded in colour in Excel.
Background: I sent out a survey in Excel to a number of people. Response came back with various fields being shaded (eg Agree, Disagree, etc). These have values of 1-5 in them. However, I need to assess the value provided on each question as a whole, hence, having them shaded doesnt help.
This brought me to the question of: How can I use IDEA to identify the value in each of the questions that was shaded in colour?

Hi,
I'm searching to modify the data that is distributed into various columns into various lines to be able to manipulate and filter information. This is somehow and example of how the columns look:
Name / Last name / Data1 ID / Data1 BEGDATE / Data1 ENDDATE / Data2 ID / Data2 BEGDATE / Data2 ENDDATE / Data3 ID / Data3 BEGDATE / Data3 ENDDATE
And this is how I need them:
Name / Last name / Data1 ID / Data1 BEGDATE / Data1 ENDDATE
Name / Last name / Data2 ID/ Data2 BEGDATE / Data2 ENDDATE
Name / Last name/ Data3 ID/ Data3 BEGDATE / Data3 ENDDATE

Hello,
I am trying to figure out a way to do a 'text to column' type of task in IDEA instead of Excel. 
I want to be able to take a file that containst a listing of names that contain the first and last name in a single field and create a separate first name field and last name field.
I am hoping for an easy solution for this, it doesnt have to be a script. 
 
thanks! 

Hi,
What would u specify to filter for data with blank dates? I presume the @isblank function work as it is for character?

Hi,
I am very new to IDEA and I have had extensive knowledge in other softwares.
Would any of you know how to specific time range? The purporse of this is to search for transactions out of the normal business hours.
If you could let me know, that will be great. Thank you!
 
EL

Hi I am trying to put together a dialog window to accomplish the following:
Dropdown that allows the user to select any field from the active databse.
Each unique value from that field show up  allowing the user to check off values to be handeled differently later in the program.
 
Is this possible, if so, do you have any resources that could help me accomplish the task? I already have the dialog box built and working for the rest of the program, I am trying to add this on.
Thanks!

Buenas.
 
No puedo colocar una foto en la ventana de mi guión, ya intente copiar el código que ofrece el explorador de lenguaje pero no me sale. Probé en un script que creé solo con ese propósito y tampoco encontré resultados buenos. A continuación se muestra el formato de la imagen, poner un control para la imagen, definir el diálogo y guardar para que se apliquen los cambios. Cualquier ejemplo funcionaría sería de gran ayuda. Gracias

Hi Brian
I may have asked already this question, I apologize if this is the case. In my old age I tend to be a bit senile. What were we talking about? Ah, keywords. Yes. Here is the problem.