Catalog Variable to select multiple dates

GD11
Tera Expert

I have a requirement to select only 1 saturday in a month and 3 in a quarter and want to have this selected as a value for 1 catalog variable, how can i do that?

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

@GD11 

OOB there is no such variable. I would suggest to create a custom table to hold saturday date of each month for the year and subsequent years. This table will have only 1 field which is of type date.

Then create a list collector variable referring to this table

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

6 REPLIES 6

AnveshKumar M
Tera Sage
Tera Sage

Hi @GD11 

There is no such type of variable to hold multiple dates in single variable available at present.

 

You can try Multi Row Variable Set.

 

Please mark my answer helpful and accept as a solution if it helped 👍✔️

Thanks,
Anvesh

@Ankur Bawiskar @AnveshKumar M it will have another variable with it (date) multi select date but that date has to be any weekday before the selected saturday? also, any idea how we can add choice values in the custom table automatically while we go forward? any BR or something

@GD11 

you can have scheduled job which runs yearly at the end of year and create records into that custom table via script and add records for saturdays for the next year

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

@Ankur Bawiskar in the same catalog i have another variable that should be multi select date but it will have any value from week previous to staturday selected, how can I achieve that?