discrete attribute that indicates the age

hehee

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

hehee

BalazsBarany 

Through where can I make the conversion? :cc

BalazsBarany

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ázs

BalazsBarany

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ázs