Year field in Table

snehalppatel

Hello All,

For one of the requirement, I need to add a Year field in the table. What is the easiest way to accomplish the task. I will also show this field on the form, from where user will enter the Year. What datatype is preferable, and how to format it?

Thanks in Advance.

kish2007

use year data type as integer. what is the issue to creating the year field in a table???



Regards,
kishore...

snehalppatel

The issue is, i want to allow users to only enter four digits for year, not less than four digits.

kish2007 wrote:

use year data type as integer. what is the issue to creating the year field in a table???



Regards,
kishore...

Savatage

how about on validate of the year field
Length := STRLEN(YEAR)
if Length <> 4 then ERROR('Invalid Year');

David_Singleton

FIrstly there is not enough information here to say if you should use a DATE, CODE or INTEGER field. But assuming you go for Integer, just set the property MINVALUE=1900 and MAXVALUE=2100 or something like that.

mihail_kolev

why not option field?? with option string=1900,1901... .. .. .. ...2049,2050

David_Singleton

mihail_kolev wrote:

why not option field?? with option string=1900,1901... .. .. .. ...2049,2050

Because it would be pretty much unusable.

kriki

[Topic moved from 'NAV 2009' forum to 'NAV/Navision' forum]

jversusj

David Singleton wrote:

FIrstly there is not enough information here to say if you should use a DATE, CODE or INTEGER field. But assuming you go for Integer, just set the property MINVALUE=1900 and MAXVALUE=2100 or something like that.

i needed to create a report request form once where the user just wanted to key in a year and this is precisely what i did. i set it to integer and entered MIN MAX values. I do recall that i then had to do some other code to make the "year" usable when setting the data filters, but it wasn't very complicated.

it worked fine.