$timestamp

[stekol61]

I will try to use he Vizlib calender in a small Sense app.

However the current dateformat doesn't seem to work in the Calender (see table below)

According to the Calender documentation i need to do this:

needs to have the $timestamp metadata tag assign to it by the Qlik Sense data model.

How do I do this?

[petter]

It is important that the field in question is really interpreted when being loaded as an actual date. Then it will automatically get the $timestamp tag assigned to it.

     Date#( yourDate, 'YYYY-MM-DD hh:mm:ss') AS yourDate

is a way of ensuring that Qlik Sense convert yourDate in a special format to an actual date within the data model.

[stekol61]

Hi!

I added: Date#([wor_event_start_time],'YYYY-MM-DD') as Date, in the LOAD script.

The result looks strange (see screenshot below).

I want to use date in the filter 'YYYY-MM-DD'. Using the current timestamp (wor_event_start_time) will not work

[PrashantSangle]

Hi,

Put Date() in front of your current expression try below

Date(Date#([wor_event_start_time],'YYYY-MM-DD'),'YYYY-MM-DD hh:mm:ss') as Date

Regards,

[petter]

Yes - sometimes you have to be very explicit to get it all right

[stekol61]

Hi!

Doesn't work.

When using your suggested expression the 'Date' is empty

[jmmolero · Accepted solution]

Hi Stefan,

Try this:

Date(Floor([wor_event_start_time])) as Date...

[stekol61]

Hi!

This solved my problem.

Thank You