Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Qlik.com |Qlik Help |Resources
Ask a Question
Turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
HelpSign In / Register
Turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
- Qlik Community
- :
- Forums
- :
- Analytics
- :
- App Development
- :
- 7-digit Julian Date convert to MM/DD/YYYY
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
AlanR
Contributor
2023-07-1107:29 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
7-digit Julian Date convert to MM/DD/YYYY
I have seen several post about this one. Looking for the correct formula to convert a 7-digit julian date (e.g. 2023015) form a field to convert into a MM/DD/YYYY Date format. The first 4 characters of the Julian date (2023) represents the year and the last 3 characters represents the day of the year (15th day of January) or 01/15/2023. I am trying to convert a field with Julian Dates to convert to the actually calendar date in Data Manager using Calculated Field.
Any advice?
Labels (1)
Labels
- Subscribe by Topic:
General Question
Ditto - same here!
4,730 Views
0Likes
- All forum topics
- Previous Topic
- Next Topic
5 Replies
md_talib
Contributor III
2023-07-1202:11 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Use this
=Date(Date#(2023015,'YYYYMMDD'),'DD/MM/YYYY')
4,707 Views
0Likes
AlanR
Contributor
2023-07-1208:08 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
In response to md_talib
Didn't quite work. Somehow I need to covert the last 3 characters (represents the day of the year) of the yyyyDDD Julian Date to Month and Day (MM/DD/YYYY)
Examples:
2023015 is 1/15/2023
2023260 is 9/16/2023
2023365 is 12/31/2023
4,692 Views
0Likes
AlanR
Contributor
2023-07-1208:52 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Here is the last 3 character conversion from the Julian date I am trying to explain.
Julian date: 2023260
Positions 1-4 is the year: 2023
Positions 5-7 is the day: 260 (260 day = September 17th)
Don't forget about leap years. I will be using this formula often.
Preview file
10 KB
4,686 Views
0Likes
Or
MVP
2023-07-1209:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Perhaps:
MakeDate(Left(YourDate,4)) + right(YourDate,3) - 1
Use the year part to establish the starting point, and then just add the number of days (subtracting one because the year starts on day 1).
4,685 Views
0Likes
AlanR
Contributor
2023-07-1209:19 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
All,
Date(MakeDate(Floor(DateField / 1000) ) + 1000 * Frac(DateField / 1000) -1)
Datefield is the field that has the Julian date format
Thanks all!
4,682 Views
0Likes
Tags
- qlik sense
- Qlik Sense Advanced Aut…
- set analysis
- sense
- qliksense
- table
- qlik
- aggr()
- qlikview
- script
- expression
- app development
- chart
- count
- filter
- kpi
- line chart
- aggr
- bar chart
- sum
View All ≫
Community Browser
- Forums
- Qlik
- Qlik Application Automation
- Catalog and Lineage
- Qlik Cloud Data Integration
- Qlik Compose for Data Lakes
- Qlik Compose for Data Warehouses
- Qlik Gold Client
- Qlik Enterprise Manager
- Qlik Replicate
- Talend
- Move to Cloud
- Stitch
- Pipeline Designer
- Design and Development
- Installing and Upgrading
- Data and Metadata Governance
- Deployment
- Administering and Monitoring
- Component Development
- 掲示板
- Qlik
- Analytics
- New to Qlik Analytics
- Move to SaaS
- Alerting
- App Development
- AI/ML
- New! Qlik Answers
- Qlik AutoML
- Insight Advisor
- Forums by Product
- Products (A-Z)
- Groups
- Industry and Topics
- Location and Language
- Leader