
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Numeric Integer conversation into date
i have a field in my database 23/01/2002 as $numeric and $interger. I want to convert that field into a date format. I tried to date(num#(datefield,'DD/MM/YYYY'),'DD/MM/YYYY') but it gives me. similarly, I have tried date(date#(datefield,'DD/MM/YYYY'),'DD/MM/YYYY')
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You could try tagging your field as $date. This is sometimes helpful when the engine struggles to determine something as a date, usually when the field has values that extend into the distant past or future.
Tag Field FieldName as '$date';

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be this
Date(Num#(datefield), 'DD/MM/YYYY') as Date
or just this
Date(datefield, 'DD/MM/YYYY') as Date

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I tried what suggested @sunny_talwar still it gives null.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you share an image of the data when you load datefield without any transformations. We need to understand how does Qlik read it before performing any transformations to it.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You could try tagging your field as $date. This is sometimes helpful when the engine struggles to determine something as a date, usually when the field has values that extend into the distant past or future.
Tag Field FieldName as '$date';
