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: 
Anonymous
Not applicable

Convert Dates from MM/DD/YYYY to Julian

Hello fellow QV friends.  I have not been able to find an example that I can use that converts date format from MM//DD/YYYY to Julian, or a five-digit date.  Do any of you know how to do this?  Thank you. 

DATE(IF(0 + LEFT(Seller_Paid_Date,2) < 30, 2000, 1900) + LEFT(Seller_Paid_Date, 2), 1, RIGHT(Seller_Paid_Date,3))  AS Test,

1 Solution

Accepted Solutions
Not applicable
Author

Try Seller_Paid_Date*1 as Test

View solution in original post

2 Replies
Not applicable
Author

Try Seller_Paid_Date*1 as Test

Anonymous
Not applicable
Author

Thank you so much!!!!!!!!!!