Date description field required

idontknowidontknow 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

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