Restrict Date Selection

We have a date field to be selected in a line item which is date formatted....Can we restrict user to select a date beyond certain user defined date field....;,e any date they want to select should not go prior Oct 2021....(which is a user defined field) and its dynamic.

Accepted answers

All comments

ManjunathKN

Hi

Yes, it is possible. can you tell me you want to restrict by months or date?

you can use DCA method to achieve this. You can create a line item (boolean) and put a logic to give false on any date before oct 21 and use it as write column for DCA for your data entry line item.

Thanks,
Manjunath

PujithaB

Hi @ekta09 ,

I do not think we can restrict the selection of date in Date Formatted line item. Its the default time settings has been provided by the system.

If there is a possibility of using Native time , instead of Date selection in line item , then the cells prior to defined Date can be restricted using DCA which is mentioned by @ManjunathKN

Thanks
Pujitha

ekta09

Hi ,

Thank You for the quick response.

I tried the stated approach but I can still see values before oct21 .

I have attached screenshots wherein date check is the boolean check used in termination date "Write DCA". T

Could you please suggest.

DateCheck_130990.JPG

TerminationDate_130990.JPG

ManjunathKN

Hi,

have you applied your date check line item as DCA write on your termination data line item in blue print view?

Thanks
Manjunath

ManjunathKN

Hi @ekta09

Dont use the termination data for your data check line item. use another line item that defines oct 21 data.

Thanks,
Manjunath

bhatjaved

I agree with @PujithaB drop down options for date entry cannot be restricted

ManjunathKN

Hi

Please find the sample example.

i see you have already created the formula for date check but you have used same termination date to compare with lauchpoint, rather you need to use the restrict date like i used and also apply DCA.(note : i have not used time here)

Thanks,
Manjunath

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…