Jan 14, 2011 #1 Greggpb88 Programmer May 18, 2010 26 ZA Hi Guys is the any way to get the Year and Period from the a date in vba beside hardcoding whar the periods are ?
Hi Guys is the any way to get the Year and Period from the a date in vba beside hardcoding whar the periods are ?
Jan 14, 2011 #2 Jay Converse Programmer Jun 17, 2007 3,277 US .Browse the CS0002 view, or add an Accpac PeriodPicker to a form, and use something like this: a4wLinkRead.GetFiscalCalendar.GetPeriodDates Me.pdPickFrom.Year, Me.pdPickFrom.period, , , bOpen Upvote 0 Downvote
.Browse the CS0002 view, or add an Accpac PeriodPicker to a form, and use something like this: a4wLinkRead.GetFiscalCalendar.GetPeriodDates Me.pdPickFrom.Year, Me.pdPickFrom.period, , , bOpen
Jan 14, 2011 #3 ettienne Programmer Oct 29, 2005 3,388 US Look at the .GetPeriod function. Upvote 0 Downvote
Jan 14, 2011 Thread starter #4 Greggpb88 Programmer May 18, 2010 26 ZA Sweet .. thanks guys Upvote 0 Downvote