Share
ReportHi there,
How do I get the business date (not todays date) using VBA?
Thanks
Jo
*This post is locked for comments
You’re offline. This is a read only version of the page.
Announcements
1,639
Hi there,
How do I get the business date (not todays date) using VBA?
Thanks
Jo
*This post is locked for comments
I may have to let someone else take a run at this. I just tried fetching bpes.today under Customization Manager and could not make that work either. It works fine under the SL toolkit for custom screens but it does appear that bpes is not available at the customization level. I will continue to play around with this as time permits.
Sorry.
I just tested this under SL 2011 and it worked for me just fine. I first looked at bpes.today with the business date not changed and it gave me 12/09/2013. I then changed the business date to 12/04/2013 and looked at bpres.today and it now gave me 12/04/2013. I did have to close the screen and re-open it after changing the business date because bpes is loaded during the form open event.
I am running these tests in a project opened in VB.NET as opposed to Customization Manager.
I am also a bit curious about the dates in your posting. While I wish it was still June, it is, unfortunately, December in my world. Also, were you really trying to change the business date to a future date?
What version of Dynamics SL are you using. I tested my response before providing it and it worked fine but I tested in under SL 6.5.
That is the business date. The bpes table holds the business date in that field. Try changing the business date and then look at that field in the table and it will contain the date you just set the business date to.
bpres.Today for the raw date or datetostrsep(bpes.Today) for the text date.
#1
Community Member
136
#2
Mohamed Amine Mahmoudi
102
Super User 2025 Season 1
#3
REUser
8
All responses (
Answers (
