Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
thnkgreen
Creator
Creator

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

Try Seller_Paid_Date*1 as Test

View solution in original post

2 Replies
Not applicable

Try Seller_Paid_Date*1 as Test

View solution in original post

thnkgreen
Creator
Creator
Author

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