- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-12-2023 06:06 AM
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-12-2023 06:17 AM
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.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-12-2023 06:16 AM
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 👍✔️
Anvesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-12-2023 07:33 AM
@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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-12-2023 07:50 AM
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.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-12-2023 08:48 AM - edited 12-13-2023 07:38 AM
@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?