Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Calendar

Hi,

I have created a calendar whose default value I want to set as today in the time-stamp format "12:00:00 PM".

cal.PNG

Here the calendar is taking value from a variable that i have defined as Variable1=today()

but default time-stamp is coming as AM only.

how to change this to PM?

Thanks in advance.

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

Because a date has a zero time value, which corresponds to a time of 12:00 AM (12 midnight)

12:00 PM has a time value of 0.5 and is 12 noon. If that's really what you want, add 0.5 to all the dates.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

2 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Because a date has a zero time value, which corresponds to a time of 12:00 AM (12 midnight)

12:00 PM has a time value of 0.5 and is 12 noon. If that's really what you want, add 0.5 to all the dates.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Anonymous
Not applicable
Author

Thanks Jonathan