Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

date/time format

HI,

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?

Thanks

5 Replies
shubham_kumar
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?

=ReloadTime()

Regards,

Shubham

pat_agen
Valued Contributor

date/time format

hi,

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

Regards,

Gordon

Not applicable

date/time format

Fulqenzio,

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

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

- Sridhar


cesaraccardi
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