About Date...

Business Central/NAV User Forum
1

hi…

If i enter birthdate in birthdate field i need to get what is the age with months and days …i’m getting till to months not getting exact code for getting the days value …so help with code of days …

for example if i enter

04/07/1989…here 4 is month and 7 is day

i need get

23yrs

1month

22days…

2

Hi, take a look at various date functions, such as DATE2DMY. Returns the day, month, or year of a Date Data ype

Number := DATE2DMY(Date, What)

‘Date’ is your date in question and ‘What’ is an integer with options of 1 (day), 2 (Month), and 3 (year). Give that a shot