Solved: Multi, non following date picker - Page 2

Jens_Damen · 04-15-2021 05:28 AM

I currently use a date picker on 2 inputs to set a start and an end date.
But the range between these 2 inputs is not always what I want.
Sometimes I might want to select 15/4, 16/4 and 21/4 but not the ones in between.

Is there a way to select multiple dates and save the selected range to 1 column?

Suvrutt_Gurjar

Absolutely.

Please create a

Date column called say [Start Date] Column Type Date
An Enumlist type column with base type as Date called say [DateRange]

The valid if of this Enumlist column will be ( a bit longer but simple expression)

LIST([Start Date] ,

[Start Date]+1,

[Start Date]+2,

[Start Date]+3,

[Start Date]+4,

[Start Date]+5,

[Start Date] +6,

[Start Date] +7,

[Start Date]+8,

[Start Date]+9,

[Start Date]+10,

[Start Date] +11,

[Start Date]+12,

[Start Date]+13,

[Start Date]+14,

[Start Date]+15,

[Start Date]+16,

[Start Date]+17,

[Start Date]+18,

[Start Date]+19,

[Start Date]+20,

[Start Date]+21,

[Start Date]+22,

[Start Date]+23,

[Start Date]+24,

[Start Date]+25,

[Start Date]+26,

[Start Date]+27,

[Start Date]+28,

[Start Date]+29,

[Start Date]+30,

[Start Date] +31)

Then the date range implementation is done

View solution in original post