• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 221
  • Last Modified:

Working with Date/Time

A form has three fields

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?
  • 2
1 Solution
Sjef BosmanGroupware ConsultantCommented:
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)))
ninteen83Author Commented:
thanks, i did not check explode
Sjef BosmanGroupware ConsultantCommented:
It's just one of those things that you must have seen or done once, and then you'll ever forget :)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now