Date & Time fields

[Groundrush]

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


thanks

 

[Bat17]

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

 

[Groundrush]

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

 

[KeithG]

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

 

[Groundrush]

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

 

[KeithG]

Below should do the trick for you.

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

 

[Groundrush]

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?

 

[KeithG]

It is for AM or PM. Why does the input mask not work?

 

[Groundrush]

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

Do I put them in the table & form design or would one suffice?

 

[Groundrush]

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

 

[Krava]

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

 

[Brianwarnock]

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

 

[Groundrush]

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

Brian

Thanks Brian

 

[Brianwarnock]

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