on 04-27-2009 5:56 PM
Hi,
Some Activity exported from Activity overview to excel have wrong date format. For example
Some have 21/04/2008 u2013 Correct
Some have 13/04/09 u2013 Incorrect
All the dateu2019s in the database seems to be correct like '2008-04-13 00:00:00.000'.
Client is using SAP B1 2005 SP01 PL-48. Is there any know issue?
I tried the same in B1 2007 upgrading the database. All the date seems to be correct when I export it here.
What may be the reason?
Any suggestions will be appreciated.
Regards,
Mohan
You have to define 4 digit year format both in B1 and OS in order to solve your problem.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
After you export to excel, Go to that particular row where date are display, There you select that row and right clike mouse-Formet Cell-under Number tab-select date then you choose which format you want then press OK
Date format in excel gives correct format.
Prasad
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Prasad,
Only certain dates in the column respond to this action, rest of them (Problematic date) did not respond.
One thing I notice is, if I click the problematic date in excel 2007 it comes up with a warning message indicating the cell is currently u2018Text Date with 2- digit yearu2019, if I change it to u2018edit in Formula baru2019 the problem disappear for that cell.
Is this a problem to do with excel or the date exported from B1?
Regards,
Mohan
Check some other available date formats in B1, such as MM/DD/CCYY.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Gordon,
It took some time for me to verify in the client machine.
I have changed the date format in both Business One and in the regional settings to DD/MM/YY. It seems to be ok however the appearances of date column in excel seems to be uneven.
04/10/09
04/11/09
13/04/09
14/04/09
19/04/09
(Ignore the *)
I think, the problematic dates seem to be exported to excel in the paste special text format.
Any Idea why this is happening?
Regards,
Mohan
Edited by: Mohanakrishnan T on May 5, 2009 1:09 PM
Edited by: Mohanakrishnan T on May 5, 2009 1:10 PM
Edited by: Mohanakrishnan T on May 5, 2009 1:11 PM
Edited by: Mohanakrishnan T on May 5, 2009 1:11 PM
You need to make sure OS date format match B1 data format. B1 format is under Admin - Sys Init - General Setting - Display. OS format is under Control Panel - Regional and Language Optios.
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Gordon,
Thanks for the response!
Both the date format is same,
I am a bit confused concerning your suggestion. As I mentioned earlier, I get 2 different date format. If OS and B1 dates are different either the year should be u20180000u2019 or u201800u2019, how come both?
Any other suggestions
Regards
Mohan
User | Count |
---|---|
86 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.