@ismember for dates

HCL Domino Domino Forum
1

Is there an @function equivalent for @ismember to use with dates? Im attempting to check a specific date (@thisvalue) to see if it exists in a list of dates (holidaylist).

HolidayList := (@DbColumn(“”:“”;“”:“”;“(HolidayView)”;1));

@IsMember(@text(@ThisValue); “HolidayList”);

On the date column in the HolidayView, I had to convert the date to text for some other calculations. But in the calculation above I used the @text formula since @ismember looks for text.

2

Subject: @ismember for dates

Should work - I tried the following and got the expected results:

REM {===================================};

@Set(“Today”; @Today);

@Set(“ALongTimeAgo”; @Adjust(Today; -500; 0; 0; 0; 0; 0));

@Set(“DateRange”; @Explode(@TextToTime(“[” + @Text(@Adjust(Today; 0; 0; -3; 0; 0; 0)) + " - " + @Text(@Adjust(Today; 0; 0; 4; 0; 0; 0)) + “]”)));

@If(

@Text(Today) = @Text(DateRange);

@Prompt([Ok]; "Whoopppeeeee"; @Text(Today) + " is in the list of dates " + @NewLine + @NewLine + @Implode(@Text(DateRange); @NewLine));

@Prompt([Ok]; "Darn it"; @Text(Today) + " is not in the list of dates " + @NewLine + @NewLine + @Implode(@Text(DateRange); @NewLine))

);

@If(

@Text(ALongTimeAgo) = @Text(DateRange);

@Prompt([Ok]; "Whoopppeeeee"; @Text(ALongTimeAgo) + " is in the list of dates " + @NewLine + @NewLine + @Implode(@Text(DateRange); @NewLine));

@Prompt([Ok]; "Darn it"; @Text(ALongTimeAgo) + " is not in the list of dates " + @NewLine + @NewLine + @Implode(@Text(DateRange); @NewLine))

);

@If(

@IsMember(@Text(Today); @Text(DateRange));

@Prompt([Ok]; "Whoopppeeeee"; @Text(Today) + " is a MEMBER of the list of dates " + @NewLine + @NewLine + @Implode(@Text(DateRange); @NewLine));

@Prompt([Ok]; "Darn it"; @Text(Today) + " is not a MEMBER of the list of dates " + @NewLine + @NewLine + @Implode(@Text(DateRange); @NewLine))

);

@If(

@IsMember(@Text(ALongTimeAgo); @Text(DateRange));

@Prompt([Ok]; "Whoopppeeeee"; @Text(ALongTimeAgo) + " is a MEMBER of the list of dates " + @NewLine + @NewLine + @Implode(@Text(DateRange); @NewLine));

@Prompt([Ok]; "Darn it"; @Text(ALongTimeAgo) + " is not a MEMBER of the list of dates " + @NewLine + @NewLine + @Implode(@Text(DateRange); @NewLine))

);

REM {===================================};

Maybe your dates include time components?

3

Subject: RE: @ismember for dates

It worked!!! Thanks!

I edited the formula and used

@IsMember(@text(@ThisValue); @TEXT(HolidayList));