Date description field required

idontknow
idontknow Member Posts: 66
Hi...

In financial management->general ledger->Budgets,i have the option to enter a date and end date over there.but now i want a field where it should print the month in words according to the date field.

Eg: If the date field is filled with the following date as 01-09-09,i want a new field which should update itself as September.

Any help?

Comments

  • kapamarou
    kapamarou Member Posts: 1,152
    You can try using the format function or using the Date virtual table.
  • Cem_Karaer
    Cem_Karaer Member Posts: 281
    "Field 2" := FORMAT("Field 1",0,'<Month Text>');
    Cem Karaer @ Pargesoft
    Dynamics NAV Developer since 2005