Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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.
Not applicable

date/time format


I would like to import a string character as 01/01/2011 11:11:11 as a julian date in loading the script.

How can I do?


5 Replies
Contributor III

date/time format

Hi there,

there are some function, if you use it will show you the julian date. try ReloadTime in script or anyware in the text object properties so that you can see the time. Is this you want?




Valued Contributor

date/time format


if you are receiving a string with the exact format you describe then the following code will turn it into a Julian date - by this I understand a 5 digit figure, the first two digits being YY followed by the number of the day in the year (is this what you are after?):

=mid(text(year(makedate(mid(vDate,7,4)))),3,2) & num((makedate(mid(vDate,7,4),mid(vDate,4,2),mid(vDate,1,2)) - makedate(mid(vDate,7,4)))+1,'000')

Not applicable

date/time format

Try this which will evaluate the incoming text string as a timestamp:

timestamp#( fieldname,'DD/MM/YY HH:MMSmiley FrustratedS') as JulianField



Not applicable

date/time format


Gordon is correct, but try using hours:minutes:second in lower case.

timestamp#( fieldname,'DD/MM/YY hh:mm:ss') as JulianField

- Sridhar

Valued Contributor

date/time format

The reason is that: If you type the minute format specially in upper case it will print the month in place of the minute.

Community Browser