Solved

Working with Date/Time

Posted on 2006-06-14
3
210 Views
Last Modified: 2013-12-18
A form has three fields

Date1
Date2
Date3 (Allow multi values)

datatype is Date/Time of all fields

If I select 25/6/2006 in Date1 and 30/6/2006 in Date2
I need all days from 25th to 30th to be inserted in Date3.
25/6/2006; 26/6/2006; 27/6/2006; 28/6/2006; 29/6/2006; 30/6/2006

any solutions?
0
Comment
Question by:ninteen83
  • 2
3 Comments
 
LVL 46

Accepted Solution

by:
Sjef Bosman earned 150 total points
ID: 16909270
That's what @Explode can do for you. From the examples in the Designer Help database:
    This example returns 07/02/96; 07/03/96; 07/04/96; 07/05/96.
    @Explode([07/02/96 - 07/05/96])

Code like
    @Explode(@TextToTime(@Text(StartDateTime) +"-"+ @Text(EndDateTime)))
0
 

Author Comment

by:ninteen83
ID: 16909395
thanks, i did not check explode
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 16909676
It's just one of those things that you must have seen or done once, and then you'll ever forget :)
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Lotus notes forward mail problem 5 416
Lotus Notes 8.5 1 154
Send a link through lotus notes automated mail 11 152
CopyAllItems causing problem with permissions 3 94
I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question