Date format in nav 09

himali

Dear all,

Does this possible to make date format 24-june-10 in nav 2009. Actaully now navision has 24-06-10 date format..but month is required in text format (june).

Thank you all in advance

idiot

Try FORMAT (somedate, 0, '<Month Text>')

himali

thanks for your reponse...but where do i apply ?

kine

where you want to display it in this format. I assume that you do not change it in whole application (it is based on WIndows settings), but only on some report. In this way you can format the output on some specific form/report...

himali

Actually i changed Date format from windows setting....still it does nt affect in report (Date filter date)

NAV_new

hi....

u can do it by Making Function,consider date as a text string and using copystr function
pick up first two word of date in a local variable ,next two word of month and similarly for year
and now check the month
if 01 then print JAN
02 then print FEB

and by using DMY2DATE function u assign value.

himali

Thanks again ....by the way i am not a Developer...i am Financial consultant...

thankesh

Does this possible to make date format 24-june-10 in nav 2009. Actaully now navision has 24-06-10 date format..but month is required in text format (june).

Hi Himali,

Yup! It is possible to change the date format. :roll: You said that you have changed the regional settings of windows. But changing the regional settings and date of windows is not required if you need this requirement in a report. If you are trying to display the date format in a report, just try this in the source expression of the text box,

FORMAT(TODAY,0,4)

Here, TODAY returns the date in which the report runs. So, change the date according to your requirement. Hope this will be helpful to you. :thumbsup:

himali

hi thankesh...thanks for your response...but where do i change or apply your instruction..can you give me location as well..

thankesh

himali wrote:

hi thankesh...thanks for your response...but where do i change or apply your instruction..can you give me location as well..

If you are trying to display the date format in a report, just try this in the source expression of the text box,

FORMAT(TODAY,0,4)

I gave the solution for your Qn in the previous post itself. If you have any doubts kindly look into report - Whse. - Receipt (7316) and run it.

himali

i am extremly sorry thankesh....but i really did nt get you...can you give me step to achieve date format 25-june-10

kine

himali wrote:

Thanks again ....by the way i am not a Developer...i am Financial consultant...

Than ask developer to do it for you. Do not try to do things, which are not part of your job, you are not specialist for that...

andy76

I am a developer and understand previous post.

I find that logging in with a user all dates are displayed in a format, logging in with another user all date fields in the system are displayed correctly.

Is there a preference/setting by user in some part of the system?

Thank you

kine

The local settings are saved per user profile in windows. Each user in window could have different local settings.

bangswit

DocumentDate --> type date
DocumentDateText --> type text

how to set 20100614 to be date type?

EVALUATE(DocumentDate,FORMAT(DocumentDateText,0,'<Year4><Month,2><Day,2>'));

--> Failed

kine

Than you need to format it by your function to some format which evaluate understand...