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.
André Arnaud de Cal... 291,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156