Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
CredoSystemz
Contributor
Contributor

Qlikview Developer

A customer has a set of date values in different formats. Some dates are in Julian date format; some dates are text strings. How can a developer ensure the data is loaded in a consistent format? <a href="https://www.credosystemz.com/training-in-chennai/best-amazon-web-services-training-in-chennai/">awstraininginvelachery</a>

Labels (4)
1 Reply
Taoufiq_Zarra

the julian date can be processed by: .

Date(MakeDate(1900 +(left(text(Julian_Date),1)* 100) +
mid(text(Julian_Date),2,2) ) + (right(text(Julian_Date),3) - 1 ) )

 

more information in this link : Julian calendar

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉