Solved: Converter numero em data - Qlik Community

Report Inappropriate Content · ‎2015-03-20

Olá a todos,

Estou extraindo informações de um banco de dados (Oracle) que trata a data como numero inteiro. Por exemplo: 19/03/2015 ele trata como 9208.

O nome do campo é ID_DT. Como faço para transformar esse numero em Ano, Mês e Dia?

robert_mika · ‎2015-03-20

If nothing will work add add 32874

32874 is 1.1.1990 in most calendar date format.

(try in Excel)

For most calendars 1 is equal to 1.1.1900.

It looks like Oracle calendar start in 1.1.1990 (which is 1)

so Date(Your field+32874)

The you can create Date,Month,Year using Qlik fucntions

View solution in original post

PrashantSangle · ‎2015-03-20

Hi,

Use Date(FieldName)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Report Inappropriate Content · ‎2015-03-20

When do this, return is 16/03/1925 and the correct it is 19/03/2015.

PrashantSangle · ‎2015-03-20

Hi,

There is no issue in Date()

Possible post sample apps.

Regards,