Current Year Variable?

[Kohli]

I have table like....

EmpID	First Name	Last Name	Gender	DateOfBirth	StartDate	EndDate	OfficeID	JobTitle
1	Erik	Fredriksen	1	5/22/1960	1/1/2008	2	CEO
2	Jenny	Olafson	0	1/18/1979	4/1/2010	2	Personal Assistant
3	Fredrik	Nilsson	1	9/12/1971	4/1/2010	2	IT Manager
4	Binh	Protzmann	1	4/5/1973	10/1/2008	1	Global Product Manager
6	Rolf	Wesenlund	1	8/29/1978	5/1/2013	2	BI Manager
7	Erin	Bell	0	10/31/1968	8/1/2010	1	CMO
8	Mike	McDonald	1	1/2/1966	7/1/2011	1	Regional Sales Manager Americas
9	Bing	Martin	1	12/12/1979	1/1/2013	2	Product Marketing Analyst
10	Ricardo	Gucci	1	4/6/1981	9/1/2012	4	Account Manager OEM
11	Gwendolyn	Cavendish	0	9/6/1977	1/1/2009	12/31/2011	2	Account Manager
12	Fiona	Hunter	0	2/22/1971	1/1/2009	6/30/2011	1	Account Manager
13	Evelyn	Brown	0	9/16/1971	3/1/2009	1/31/2012	2	Account Manager
15	Helena	Du Froid	0	6/18/1960	7/1/2011	4	Regional Sales Manager Europe

I want create the variable for Current Year . Please suggest me how to create the variable for that?

[bbmmouha]

do you whant the age ??

age(Now(),DateOfBirth) as age

or you whant the year from StartDate ?

Year(StartDate) as year

may you explane

[balabhaskarqlik]

May be:

Let vYear = Year(Today());

Let vYear1 = Year(Date(Today(), 'MM/DD/YYYY'));

[jonathandienst]

Your first expression is OK, but the Date formatting function here:

Let vYear1 = Year(Date(Today(), 'MM/DD/YYYY'));

is completely superfluous.

[Kohli]

Hi bala, r u from bangalore.