Solved

Working with Date/Time

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video discusses moving either the default database or any database to a new volume.

707 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

12 Experts available now in Live!

Get 1:1 Help Now