Solved

Working with Date/Time

Posted on 2006-06-14
3
207 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

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 6.5 low performance 13 36
names.nsf ODS upgrade 4 425
Lotus notes - forward mails agent with these conditions in subject, 3 220
External emails not coming through 3 101
For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

895 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now