Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a field called HOUR BLOCK (0,1,2,3,4-23) corresponding to 12:00 AM - 11:00 PM.
How do I go about mapping the true times to the numeric values. I have created an inline table:
TimeMap:
LOAD * INLINE
[HOUR BLOCK, Real Time
0, 12:00 AM
1, 1:00 AM
2, 2:00 AM
3, 3:00 AM
4, 4:00 AM
5, 5:00 AM
6, 6:00 AM
7, 7:00 AM
8, 8:00 AM
9, 9:00 AM
10, 10:00 AM
11, 11:00 AM
12, 12:00 PM
13, 1:00 PM
14, 2:00 PM
15, 3:00 PM
16, 4:00 PM
17, 5:00 PM
18, 6:00 PM
19, 7:00 PM
20, 8:00 PM
21, 9:00 PM
22, 10:00 PM
23, 11:00 PM];
I think you don't need a mapping for it - a time(maketime([HOUR BLOCK])) should be enough.
- Marcus
Hello Evan,
Not sure if you need an external mapping table to convert time components into a complete date/time.
Use the MakeTime() function: =MakeTime(15,10,05)
so, place your field which has the hour value into the function:
=MakeTime(MyHourField,0,0)
I think you don't need a mapping for it - a time(maketime([HOUR BLOCK])) should be enough.
- Marcus
Oh! You went with Marcus's answer?!! I had already worked out how to spend the points!! (there was gonna be accolades, feting, shopping sprees, everything!!)
*thank you Marcus