discrete attribute that indicates the age
hehee
New Altair Community Member
Hello!
My query is ..
How can I get to the following:
"Generate a new discrete attribute that indicates the age of the
people as of August 8, 1934 "
The above, taking into account that:
DOB are represented in the table as:
August 18, 1990
Help pls
Tagged:
0
Best Answers
-
0
-
Hi!
There is an operator "Nominal to Date" you can use for converting textual dates or timestamps to the proper type. Or you check out the Conversion functions in Generate Attributes. (When you open the dialog box, you have a calculator icon on the right. This opens the function browser you can use to search for functions applicable to your data processing, and read their description.)
Regards,
Balázs5
Answers
-
Hi @hehee,
the Generate Attributes operator can help you here. It allows you to create new attributes using formulas and functions (similar to programming languages or Excel).
Check out the conversion and the date functions there.
For converting other representations into dates, or generating the comparison date (1934-08-08) you could use the date_parse or date_parse_custom functions.
For comparing dates and timestamps there is date_diff.
Regards,
Balázs0 -
0
-
Hi!
There is an operator "Nominal to Date" you can use for converting textual dates or timestamps to the proper type. Or you check out the Conversion functions in Generate Attributes. (When you open the dialog box, you have a calculator icon on the right. This opens the function browser you can use to search for functions applicable to your data processing, and read their description.)
Regards,
Balázs5