Not applicable
2011-03-15
04:44 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Julian Date Conversion
Is there a built-in function or can one be created to convert from a Julian date to a recognizable date in QlikView?
- Tags:
- date_and_time
4,457 Views
2 Replies
Not applicable
2012-11-30
12:07 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
LET CurrentJulian = 112333;
LET Gregorian_Date = date(yearstart(makedate(((($(CurrentJulian) - fmod($(CurrentJulian),1000)) / 1000) + 1900))) + (fmod($(CurrentJulian),1000) - 1));
No function exists that I know of but the code above works
1,739 Views
beristardj
Creator
2018-09-12
03:18 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Exist the function name is DayNumberOfYear
1,739 Views