Discussion board where members can get started with QlikView.
i have Time stamp field
by using Time stamp i want to create Date like below table
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
View solution in original post