Hi,I am trying to find the array or list of dates stored in a field “STARTDATETIME” of the calendar document. I want to find the dates which falls in the specified date range. and StartDAteTime field contains those list of dates, and i want to retrieve all dates which falls in that range…IS THERE ANY FORMULA WHICH CAN GIVE ME THOSE DATES>…PLEASE HELP ME OUT…if any one knows…
thanx in advance
regards
amit saini
Subject: check out @explode(DateRange)
if you have just two dates (wich is not the same as a date range) then you can use something like :
@Explode( @TextToTime(“[”+@Text(StartDate)+“-”+@Text(EndDate)+“]”))
Subject: RE: check out @explode(DateRange)
HiYou could try to set the selection formula with lotus script. Look at the help for notesview selectionformula. There is an example that looks like something you could use. If you want to do this, use a private view. Otherwise every users changes the view for everybody.
Hope that helps.
cti