You’re offline. This is a read only version of the page.
Dear All,
I will facing the issue of Excel add-ins date error,
Actual data range is Fr date - 01-04-2015 To date - 31-03-2016
if im paste that data in excel system automatically converting the date
Fr date is 04-01-2015 to date - 03-01-2016.
Please help us to solve this issue..!!
*This post is locked for comments
Would you please verify the answer if it helps you.
Dear Fareed,
Thank you...!!
I modified my coding what you mention in your link.
Hi Chandru,
What do you mean by pasting data in excel? I wonder you are importing data through excel add-ins. Can you please more about your requirement.
If you are using some X++ code to import data then you need to format your date, have a look on this blog daxdude.blogspot.com.au/.../ax-x-str2date-function-deep-dive.html
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,228
Super User 2024 Season 2
#2
Martin Dráb
230,056
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (