Excellent video as always. This seems really powerful, sadly every example online is for just dates. but the DateTime one OnResolveDateTokenFromDateTimeFilter seems odd as the signature is local proceedure MyFilter(DateToken: Text; var DateFilter: Date; var Handled: Boolean) So unlike the simple date example where you had a from date and a to date the datatime version seems to have a single DateFilter variable of type Date. So I am struggling to see how you can set DateFilter when you have two datetimes. My use case is I want to create a filter thismonth and lastmonth but on datetime fileds not date fields. It feels like it should be simple but I cannot get it to work. Any ideas?
Hi Erik I have tried same coding in my environment but if I give party in date filter.. the condition I snot going inside the function loop Do you have any idea y so
This is cool as long as the users use the right posting date for the transactions relating to the party. Also would be helpful to be able to set the “events” up in BC without code 😳😉 Ordering your book today, thanks for the reminder.
Yes, some users type texts like p1 for January into date filters, but most users type full dates and date ranges into BC the same way they do it in Excel. The thank me for my training effort but say having to remember two methods for two apps is too much.
Excellent video as always. This seems really powerful, sadly every example online is for just dates. but the DateTime one OnResolveDateTokenFromDateTimeFilter seems odd as the signature is
local proceedure MyFilter(DateToken: Text; var DateFilter: Date; var Handled: Boolean)
So unlike the simple date example where you had a from date and a to date the datatime version seems to have a single DateFilter variable of type Date. So I am struggling to see how you can set DateFilter when you have two datetimes.
My use case is I want to create a filter thismonth and lastmonth but on datetime fileds not date fields. It feels like it should be simple but I cannot get it to work. Any ideas?
Thanks for this amazing video, Erik.
I have seen the "handled" variable all over the Base App Code. Could you tell me how it works?.
Thanks
Handled is used when you want to disable the regular Microsoft process and replace with your own.
@@Hougaard Thanks, that will be useful.
Hi Erik
I have tried same coding in my environment but if I give party in date filter.. the condition I snot going inside the function loop
Do you have any idea y so
Whar?
@@Hougaard the same coding is not working in my environment
@@bharath70 What version? Cloud?
@@Hougaard BC18 and on premise
Did you find any specific reason for not working the code?
This is cool as long as the users use the right posting date for the transactions relating to the party. Also would be helpful to be able to set the “events” up in BC without code 😳😉 Ordering your book today, thanks for the reminder.
... if only someone was working on a "Simple Object Designer" kinda app??
@@Hougaard YES! But then I’d say just use a dimension to report on. #tocodeornottocode
Cool feature! I will use it right way ;)
Yes, some users type texts like p1 for January into date filters, but most users type full dates and date ranges into BC the same way they do it in Excel. The thank me for my training effort but say having to remember two methods for two apps is too much.
Wow! Nice one!
Powerful stuff indeed