Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Working with Date/Time

Posted on 2006-06-14
3
Medium Priority
?
215 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 46

Accepted Solution

by:
Sjef Bosman earned 450 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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…
Article by: Rob
Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

636 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