Postings from the India IDEA data Analysis software users group
This forum will contian tips from the India IDEA Data Analysis Software Users Group. If you are interested in joining them you can find them on google groups at http://groups.google.com/group/idea-data-analysis-software-users---india
EXTRACTION OF DATES IN DD/MM/YYYY FORMAT FROM EXCEL
Hello. I have a project which requires me to extract a series of dates from a field named TERM_DATE from an uploaded Excel spreadsheet into Idea. The instruction I was given was to use TERM_DATE <> " in the equation editor, which is supposed to extract terminations not equal to blank but returns a Mismatch field type error. The dates are in the dd/mm/yyyy format as they appear in the database, but Idea is set to yyyy/mm/dd format. The extracion fails, I suspect it has to deal with the differnet date formats, and I've tried several times to append the date field to no sccess.
Time difference between 2 date and time values
In a database, there are 4 columns (2 date values i.e. start date and end date and 2 time values i.e. start time and end time). In other dates, start is represented in 2 separate columns (date and time) and end is represented in 2 separate columns (date and time). I want to find the difference between start and end (in number of days upto 2 decimal places) considering both date and time. What would be the equation?
Set AddedField = NewTable.NewField
AddedField.Name = "ChangedOnDateFA"
AddedField.Type = WI_DATE_FIELD
AddedField.Length = 10
To Apply an Import Template
- Read more about To Apply an Import Template
- 2 comments
- Log in or register to post comments
Choose your Delimiter Correctly - Text File Imports
- Read more about Choose your Delimiter Correctly - Text File Imports
- Log in or register to post comments
Header Lines to Ignore - Import of Text Files
- Read more about Header Lines to Ignore - Import of Text Files
- Log in or register to post comments
The @Val() and @CurVal() Functions in IDEA
Hello Group Members,
- Read more about The @Val() and @CurVal() Functions in IDEA
- Log in or register to post comments
View - Date Values
Hello Group Members,
- Read more about View - Date Values
- 5 comments
- Log in or register to post comments
Facility Management Services - Billable Days Vs Agreement Coverage Case Study
Hello Group Members,
Find and Replace in the Equation Editor
Hello Group Members,
- Read more about Find and Replace in the Equation Editor
- Log in or register to post comments
Difference in = and == in the Equation Editor
Hello Group Members,
- Read more about Difference in = and == in the Equation Editor
- Log in or register to post comments