Date & Time fields

Groundrush

Registered User.
Local time
Today, 21:36
Joined
Apr 14, 2002
Messages
1,376
I'm capturing the date & time in a field by using the =now() method.

When a record is created it will log the current date & time without any user input
eg.
08/01/2007 10:39:03 (in one field)

I now need to be allow the user to manually enter date & time info into another field for calculation purposes

The questions I now have is:

How do you manually enter date & time details into a field that stores both the date & time without it getting messy or complicated or would it be better to have two fields for the date & time then somehow store the results in one field in the main table?


If that makes any sense :o


thanks
 
depends on how dense your users are :)
I would probably set up a mask for '08/01/2007 10:39' and just make them type it in.
If they are not upto that you could add a calander picker field, I belive there is a sample here somewhere that has a time picker as well

Peter
 
Bat17 said:
depends on how dense your users are :)
I would probably set up a mask for '08/01/2007 10:39' and just make them type it in.
If they are not upto that you could add a calander picker field, I belive there is a sample here somewhere that has a time picker as well

Peter

I need to make this as simple as I possibly can, I also need to make it quick & easy to input date & time values, I think a date & time picker will take too long to use.

Can anyone suggest how to go about concatenating the two values & store them both together in one field?

thanks
 
I agree with Bat17 on using the input mask. Do you not want to use an input mask?
 
KeithG said:
I agree with Bat17 on using the input mask. Do you not want to use an input mask?

Yes I do want to use them.

I experimented with input masks today but could not work out how to create a mask for a date & time field

I'm now thinking of two fields on a form that have input masks for date & one for time

then the results are saved in one date field (general date)
eg.
08/01/2007 10:39:03

unless anyone can think of a better way
 
Below should do the trick for you.

##/##/####\ ##:##:##\ LL;0;
 
KeithG said:
Below should do the trick for you.

##/##/####\ ##:##:##\ LL;0;

thanks for that

I have tried it but it didn't work properly, but I think we're on the right track though :)

What does the LL;0; do?
 
Last edited:
It is for AM or PM. Why does the input mask not work?
 
KeithG said:
It is for AM or PM. Why does the input mask not work?


I'll try again

I've never really used input masks before so please bear with me on this :o

Do I put them in the table & form design or would one suffice?
 
KeithG said:
It is for AM or PM. Why does the input mask not work?

because of the AM & PM.......lol

thanks it does work now but I would prefer not to have to input the the am or pm
 
Hi!
Are they going to input current date and time at the moment they fill out the form? If yes, build a simple button that will fill out the desired field with now() value.

Krava
 
Groundrush said:
thanks it does work now but I would prefer not to have to input the the am or pm

Then ##/##/####\ ##:##:##;0; should give you what you require.

Brian
 
I thought sheesh what's this, then I looked at the dates :) ,I cant remember things from more than a few days ago , you must be a busy boy, anyway glad it worked.

Brian
 

Users who are viewing this thread

Back
Top Bottom