SAC Set Date Range for Current Date Dropdown Available - am ADMIN

[avidear10]

Am trying to create a new dynamic date filter but do NOT see the drop-down below Current Date, which shows System Date/Period.

Have System Admin Role

The graphic is below from the documentation, what am I missing?

[DebjitSingha]

Hello avidear10,

Can you check in the model if your date field is considered as "Date" compatible field in SAC. If so field sill appear with date icon like below:

Other way to tell if your field is compatible is to see if you can get below option under context menu of concerned field.

If not, try to change the field type during model building phase itself. or perform a re-build action on existing model.

In case of live connection, depending upon your source you need to take necessary action at the source.

Note: if your field doesn't have date level granularity then also you will not see this option.

Viewers/ readers - If you find above information helpful, feel free to up-vote (arrows on left side).

-Debjit

[avidear10]

Thanks for your prompt response.

Funnily it was there for some ittermintent reason, but not now, when I recreate the story.

Appreciate your detailed response and the effort.

Continue to support the community by your insight and effort.