espoc date converstion to Qlik format

[Anonymous]

Hi I am currently loading Oracle data into Qlikview, I have a date field creation_date as

1	1052931376000
2	1052931469000
3	1052989210000
4	1052989493000
5	1052989855000
6	1052990059000

Now I want to convert this into human date field into YYYYMMDD format.

I am currently using "Timestamp(MakeDate(1970) + creation_date/60/60/24) as creation_date" but output is something like this

17/02/35303 17:13:20

I want it to be YYYYMMDD format, Please advise

Thanks for your help

[Anonymous]

Thanks a lot..........

[Anonymous]

Thanks Sunny

[Anil_Babu_Samineni]

From sunny, expression.

=Date(MakeDate(1970) + FieldName/60/60/24/1000,'YYYYMMDD')

[its_anandrjs]

Try with this

=Date(Timestamp(MakeDate(1970) + creation_date/60/60/24/1000),'YYYYMMDD')

[sunny_talwar]

I would suggest you to add Floor here also

Date(Floor(MakeDate(1970) + FieldName/60/60/24/1000),'YYYYMMDD') as Date

[Anil_Babu_Samineni]

Yes, Or else it consider as String due to MakeDate(). Thanks for prompt

[sunny_talwar]

Or else it consider as String due to MakeDate().

What will be considered as string? The reason you need Floor is to remove the time component from this timestamp... String/Numbers has nothing to do with adding Floor. As long as you use date, it is a dual field with underlying numeric value