Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have following chart
How to separate the column date.
I need to have one column only for the date and another column for the time.
Someone have an idea, how to solve this problem?
date |
17/07/2013 18:02 |
17/07/2013 18:03 |
17/07/2013 18:03 |
17/07/2013 18:04 |
17/07/2013 18:04 |
17/07/2013 18:04 |
17/07/2013 18:17 |
17/07/2013 18:20 |
17/07/2013 18:21 |
17/07/2013 18:21 |
17/07/2013 18:44 |
17/07/2013 18:45 |
17/07/2013 18:45 |
17/07/2013 18:46 |
17/07/2013 18:46 |
18/07/2013 06:35 |
18/07/2013 06:35 |
18/07/2013 06:59 |
18/07/2013 07:00 |
18/07/2013 07:00 |
18/07/2013 07:10 |
18/07/2013 07:14 |
18/07/2013 07:18 |
You can use
Date(Floor(DateFeld)) AS Date
Time(Frac(DateField)) AS Time
For date, try = Date(YourDateField, 'DD/MM/YYYY')
and for Time, =Time(TimeStamp#(YourDateField, 'DD/MM/YYYY hh:mm'), 'hh:mm')
hello Pascal,
see attached
Regards
You can use
Date(Floor(DateFeld)) AS Date
Time(Frac(DateField)) AS Time
Thank you Celambarasan, it's working perfectly!