Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[John Sauber]

Does anyone have any thoughts on how one could hard-code today’s date as a filter value in the development environment? If I use something like WHERE(Date=FILTER(>’t’), then the result simply evaluates ‘t’ as the current date upon compiling. The next day the object is opened, the ‘t’ is gone, and the value (now yesterday) is present. How can I hard-code this in the development environment. It doesn’t appear that the normal date shortcuts are allowed here.

Thanks for any insight here!

John

——————————
John Sauber
Sauber Mfg. Co.
——————————

[Franz Kalchmair]

please describe in more detail what you need.
in the dev env it isn’t possible to save filters for own commands.
in c/al you have the today command for setting in date filters.

——————————
Franz Kalchmair
Microsoft MVP
Senior Consultant
Vienna, Austria, Europe
——————————
——————————————-

[Richard Folkner]

Try,  WHERE(Date=FILTER(>TODAY)   or  WHERE(Date=FILTER(>WORKDATE).

——————————
Richard Folkner
——————————
——————————————-

[John Sauber]

Thanks for the replies, both!

The screenshot below is what I’m trying to use to capture “today”. It is the properties of a ListPart, which is a factbox that displays a list of dates given certain criteria as can be seen in the SOURCETABLEVIEW property. Essentially, this is a list that shows all of the future dates that don’t already have 7 or more to-do’s, that fall on workdays only. When I add this factbox to another page, it’s link is to the variable %USER so that it’s tailered to whoever is logged in. This helps us more evenly distribute our to-do’s as we create them.

The functionality I’m trying to accomplish with >TODAY is to only show dates in the future.

Rick, if I try your suggestions of TODAY and WORKDATE, just like ‘t’, those are simply evaluated upon compiling and are then hardcoded to 2/27/2018, which it stays at.

——————————
John Sauber
Sauber Mfg. Co.
——————————
——————————————-

[Franz Kalchmair]

ok, that’s different.
best you make that in the page’s onopenpage by code via setrange/setfilter.

——————————
Franz Kalchmair
Microsoft MVP
Senior Consultant
Vienna, Austria, Europe
——————————
——————————————-

[Jason Luchka]

?We have similar custom activity cues in our role centers. We use Date Filter Flowfilters and code in OnOpenPage (for the activity cue) that passes dates into a table function (the activity cue table) to populate the Date Filter. It works like a charm.

Perhaps you can start by reverse engineering some standard activity cues (as we did).

——————————
Jason Luchka
Programmer / Analyst
FFR Merchandising, Inc.
Twinsburg OH
——————————
——————————————-

[John Sauber]

Thank you for the suggestion. That all sounds good except for the OnOpenPage portion. Our organization does not have a developer’s license. I was hoping to do this the easy way, but it sounds like a chat with the VAR is in order, unfortunately.

——————————
John Sauber
Sauber Mfg. Co.
——————————
——————————————-

[Richard Folkner]

Looks like you would probably have to set the filter through code on the page, TODAY and WORKDATE are system variables and through code get evaluate each time it runs.  I’ll play around with it and see if there is a way to do it in the sourcetableview.

——————————
Richard Folkner
——————————
——————————————-