Hi,
How can i take just a Current year, not all the date as it is the function.
I need to validate a field that it couldn’t be greater than current year in our case 2010.
It is any funcion that i can taka just a current year.
Hi,
How can i take just a Current year, not all the date as it is the function.
I need to validate a field that it couldn’t be greater than current year in our case 2010.
It is any funcion that i can taka just a current year.
DATE2DMY(YourDateVariable,3)
will give you the year part of yourdatevariable.
1gives : Date
Month
Year
Use DAT2DMY(TODAY,3). This retireves the current year.
Marco