Splitting date and time help
Hi,
In my form there are 3 fields I need help with,
Field A. date and time field
Field B. Date field
Field C. Time field
What I want is when Field A is filled Field B is filled with the date part of Field A and Field C is filled with the time part of field A.
So
Field A = 28-Mar-2013 09:00:00
Field B = 28-Mar-2013
Field C = 09:00:00
Can anyone help please
Nigel