VishalMistry
8th August 2009, 09:59
hi all,
i want to print date as dd/mm/yyyy. Is there any baan date domain available that supports this format or how this can be done. pl guide.

vishal

zacharyg
8th August 2009, 18:14
Hello Vishal,

you can create the desired date format using session ttadv4180m000.

manish_patel
9th August 2009, 11:36
First check in data dictionary that specific date format (i.e. dd/yy/mmmm) is already defined or not. If it is already there; just use it with sprintf$() (http://www.baanboard.com/programmers_manual_baanerp_help_functions_formatting_io_sprintf) function. Otherwise first defined it and then use it with sprintf$() function.
Example:
| Suppose date format 002 is: "day/month/year"
sprintf$("%D002", date.num())

Other way is to define your own date format by using the %m, %d, %Y subformats of the ā€˜%D’ format in sprintf$() function.
Example:
sprintf$("%D(%02d/%02m/%04Y)", date.num())

VishalMistry
10th August 2009, 09:06
thanks manish,

now the issue is resolved.

vishal