asked on

Working with Date/Time

Hello experts

I have two fields
ScheduledDaysAll - Date/Time, Computed, I'm doing a dblookup here to get multiple Dates from other documents. (e.g. 08/03/2006, 08/04/2006, 08/05/2006)

StartDate - Date/Time, @If(@IsMember(StartDate;@TextToTime(ScheduledDaysAll));@Failure("An existing modules is covering this day !");@Success)

When I select any date in StartDate, I get this message.. 'Incorrect data type for operator or @function: Text expected'

I'm trying to prevent users to select those dates/days which are already exists in ScheduledDaysAll

Harisha M G

Hi, you are passing a date-time value to the functin @TextToTime(), which expects a string to be its parameter

http://www-12.lotus.com/ldd/doc/domino_notes/Rnext/help6_designer.nsf/f4b82fbb75e942a6852566ac0037f284/9ef4e6e6732021f885256c54004c1363?OpenDocument

---
Harish

ninteen83

ASKER

Hi Harish

I've tried it without texttotime, but I get the same error

@If(@IsMember(StartDate;ScheduledDaysAll);@Failure("An existing modules is covering this day !");@Success)

ASKER CERTIFIED SOLUTION

Steve Knight

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

marilyng

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

marilyng

I'm sorry, did we not answer your question correctly? I created a test environment before I posted?! Could you tell us why the grade is a B?