How do I check if catalog variable date is between today and 7 days from today

[Mike LHCG1]

I have a requirement to check if a catalog variable date is between today and 7 days from today. I haven't found a way to do it with catalog policies. Does anyone have a solution for this that they can share with me? I would appreciate it if in addition to what needs to be done, if you could share how it's done. Thank you.

[jonsan09 · Accepted solution]

You could utilize catalog client scripts that run while the user fills out the catalog item. See this article with script examples: https://www.servicenow.com/community/developer-articles/date-validations-client-scripts/ta-p/2298860

[VaishnaviK3009]

Hi @Mike LHCG1 !!

To enforce a date between today and 7 days from today, use a Catalog Client Script (recommended: onSubmit).

Example (onSubmit Catalog Client Script):

function onSubmit() {
    var dateStr = g_form.getValue('your_date_variable');
    if (!dateStr) return true;

    var selectedDate = new Date(dateStr);
    selectedDate.setHours(0,0,0,0);

    var today = new Date();
    today.setHours(0,0,0,0);

    var maxDate = new Date(today);
    maxDate.setDate(today.getDate() + 7);

    if (selectedDate < today || selectedDate > maxDate) {
        g_form.showFieldMsg(
            'your_date_variable',
            'Date must be between today and 7 days from today.',
            'error'
        );
        return false;
    }
    return true;
}

Mark this as Helpful if it clarifies the issue.
Accept the solution if this answers your question.

Regards,
Vaishnavi
Associate Technical Consultant

[AndersBGS]

Hi @Mike LHCG1 ,

Why not creating a catalog client script to ensure that the date is between now and 7 days from now?