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

How I can subtract minutes to format NOW?

I need to subtract 30 minutes to the current time to determine if information entered during each 30 minutes.

Thanks for your help.

3 Replies
Gysbert_Wassenaar

time(now() - 1/48,'hh:mm') will subtract 30 minutes, 1/48th part of a day, from now() and show it in hh:mm format


talk is cheap, supply exceeds demand
tresesco
MVP
MVP

try:

timestamp(now()-time#(30,'mm'))

or,

Timestamp(now()-30/24/60)   // 1 means a day, hence 30 mins=30(1/24/60), or directly 1/48

Logistix
Contributor II
Contributor II

Excuse me, I need to do the same thing but this time, I need to subtract 10 minutes to the current date. Considering your answer, I think It'd be something like this:  

Now()-10/24/60

 The thing is I don't understand the process. Can you explain it deeper?

I don't really get why i need to divide 30, 24 and 60.