Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i have Time stamp field
Time Stamp |
---|
12/08/2017 00:00:00 |
12/08/2017 00:15:00 |
12/08/2017 00:42:00 |
12/08/2017 00:15:00 |
12/08/2017 00:15:00 |
12/08/2017 20:15:00 |
12/08/2017 23:15:00 |
12/08/2017 23:55:00 |
12/09/2017 00:00:00 |
12/09/2017 01:00:00 |
12/09/2017 02:10:00 |
by using Time stamp i want to create Date like below table
Time Stamp | Date |
---|---|
12/08/2017 00:00:00 | 12/07/2017 |
12/08/2017 00:15:00 | 12/08/2017 |
12/08/2017 00:42:00 | 12/08/2017 |
12/08/2017 00:15:00 | 12/08/2017 |
12/08/2017 00:15:00 | 12/08/2017 |
12/08/2017 20:15:00 | 12/08/2017 |
12/08/2017 23:15:00 | 12/08/2017 |
12/08/2017 23:55:00 | 12/08/2017 |
12/09/2017 00:00:00 | 12/08/2017 |
12/09/2017 01:00:00 | 12/09/2017 |
12/09/2017 02:10:00 | 12/09/2017 |
May be this
Date(Floor(TimeStamp - MakeTime(0, 0, 1))) as Date
Update: I basically subtracted 1 second from your timestamp so that 12/08/2017 00:00:00 becomes 12/07/2016 23:59:59 before we floor it to a date
May be this
Date(Floor(TimeStamp - MakeTime(0, 0, 1))) as Date
Update: I basically subtracted 1 second from your timestamp so that 12/08/2017 00:00:00 becomes 12/07/2016 23:59:59 before we floor it to a date