Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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.

Labels (1)
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