How to create field with date

[#1]

Hi,I have 3 fields with Day, Month and Year and would like to get one Date field. Can somebody help me with that?

Later, I would like to use this field in criteria where I want to show only those records where the date is older than the current date. Any clues where I can find my solution?

Thanks

[#2]

SET ThousandSep=' ';

SET DecimalSep=',';

SET MoneyThousandSep=' ';

SET MoneyDecimalSep=',';

SET MoneyFormat='# ##0,00 €;-# ##0,00 €';

SET TimeFormat='h:mm:ss';

SET DateFormat='D. M. YYYY';

SET TimestampFormat='D. M. YYYY h:mm:ss[.fff]';

SET MonthNames='1;2;3;4;5;6;7;8;9;10;11;12';

SET DayNames='po;ut;st;št;pi;so;ne';

ODBC CONNECT32 TO [MS Access Database;DBQ=D:\Ocelik\ROK_2013.mdb];

SQL SELECT *

FROM MSysAccessStorage;

LOAD

MakeDate([C068_RokSplatnosti],[C067_MesSplatnosti],[C066_DenSplatnosti]) as `DateField`;

SQL SELECT `C000_ID`,

    `C001_Vymazany`,

    `C002_Oznaceny`,

    `C003_Zamknuty`,

    `C004_Systemovy`, .

.

.

.

       .

.

.

    `C254_PohladavkaZavazok`,

    [C228_UhradeneTM]*[C221_SumaSpoluNizsia] as `Received Value`

FROM `T040_EUD`;

I have posted my script. I can´t find my new field in sheet propertis in available fields and I can´t find my new field in table box properties in available fields. 

[CELAMBARASAN]

LOAD *,

MakeDate([C068_RokSplatnosti],[C067_MesSplatnosti],[C066_DenSplatnosti]) as DateField

Where MakeDate([C068_RokSplatnosti],[C067_MesSplatnosti],[C066_DenSplatnosti]) <= Today();//To get date before the current date

SQL SELECT `C000_ID`,

    `C001_Vymazany`,

    `C002_Oznaceny`,

    `C003_Zamknuty`,

    `C004_Systemovy`, .

.

.

.

       .

.

.

    `C254_PohladavkaZavazok`,

    [C228_UhradeneTM]*[C221_SumaSpoluNizsia] as `Received Value`

FROM `T040_EUD`;

[preminqlik]

table1:

SQL SELECT `C000_ID`,

    `C001_Vymazany`,

    `C002_Oznaceny`,

    `C003_Zamknuty`,

    `C004_Systemovy`, .

.

.

.

       .

.

.

    `C254_PohladavkaZavazok`,

    [C228_UhradeneTM]*[C221_SumaSpoluNizsia] as `Received Value`

FROM `T040_EUD`;

table2:

noconcatenate

load *,MakeDate([C068_RokSplatnosti],[C067_MesSplatnosti],[C066_DenSplatnosti]) as [Date Field]

resident table1;

drop table table1;

[#5]

Yep  Thanks  but I need in date field all dates , not only To get date before the current date.

[CELAMBARASAN]

Remove that where condition

LOAD *,

MakeDate([C068_RokSplatnosti],[C067_MesSplatnosti],[C066_DenSplatnosti]) as DateField;

SQL SELECT `C000_ID`,

    `C001_Vymazany`,

    `C002_Oznaceny`,

    `C003_Zamknuty`,

    `C004_Systemovy`, .

.

.

.

       .

.

.

    `C254_PohladavkaZavazok`,

    [C228_UhradeneTM]*[C221_SumaSpoluNizsia] as `Received Value`

FROM `T040_EUD`;