Hi
I have a room request database that a user enters a start date and end date for a meeting.
On a tabbed table below there is a row for each day of the week and based upon the start and end dates I would like the corresponding date to populate in a field in the tabbed table.
Does anyone know an easy way to do this? I am trying it in formula language and it just doesn’t seem to be working.
Thanks for the help.
Subject: Populating Date Fields
Can I ask why? Why not have a date range field that is a multi-value field the captures all the dates in between- that way you can more easily display it in a calendar view- one of Notes/Domino strengths is its ability to manipulate multvalue fields.
Subject: RE: Populating Date Fields
Why do I have 2 date fields?
I guess I can have a field that lists all the dates b/t the start and end date and then use an array to pull out the values? Would that work?
Subject: Populating Date Fields
Use @Adjust inside of another date field at the top of each day column (or more likely), use @Text(@Adjust(… to create a computed text column header.