Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
thnkgreen
Contributor

Julian Date with day always 1

Hello everyone.  I have a date column with five digit dates (Julian, I think) that I need to convert to m/d/yyyy.  I tried

Date(datefield, 'm/d/yyyy') as new date

However, the dates look like (for example) 0/1/2015 after conversion of a date 42339.  The original data appears to have the month, a 1 for the day (always) and the year for this column.  The correct answer for this date should be 8/1/2015.

Any ideas?  Thanks

1 Solution

Accepted Solutions
MVP
MVP

Re: Julian Date with day always 1

Try

Date(datefield, 'M/D/YYYY')


(month format code is 'M', 'm' denotes minutes, see the help for details on format codes)

2 Replies
MVP
MVP

Re: Julian Date with day always 1

Try

Date(datefield, 'M/D/YYYY')


(month format code is 'M', 'm' denotes minutes, see the help for details on format codes)

thnkgreen
Contributor

Re: Julian Date with day always 1

Thank you.  So simple!!!

Community Browser