Hello all,

Might be a very small thing for gurus but i have stucked in it.

I have a date field on form which is in MMDDYY format. But i need to display it as YYMMDD format.

How can be do it???




Suggestions are welcomed
thanks and regards

Hi,

I would use the sprintf$ function (http://www.baanboard.com/programmers_manual_baanerp_help_functions_formatting_io_sprintf):
http://www.baanboard.com/programmers_manual_baanerp_help_functions_formatting_io_sprintf

Hi,

But sprintf$ returns string which worked well if i need to print on a report but i need to display it on a form(say a table field on form of type date). Sprintf$ didn't work there.





Any other help.

Thanks

You can use date formats %D999 stored in dd specifically created for this. Have u tried this.

Thanks Histesh,

I haven't tried this format. I will try and revert back.

Thanks again

Hi,


I am working on FP7, here i find that there is no %D999 format in the DD.
I searched for this format in session code ttadv4580m000.






Thanks

Hi,

For the Date format displayed on the form also depends on the local machine's date format. Can you try to change the date format on your local machine, by going through

Control Panel -> Region and Language -> Regional Options (tab) -> Customize (button) -> Date (tab)

Here set the date format you require. Then re-login to Baan.

I hope it helps you.

Kind Regards,
--Rahul

Hi,

I feel Rahul's comment will solve this issue because form fields date format depends on your local machine setting.

Regards,
Gaurav