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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
anuradhaa
Partner - Creator II
Partner - Creator II

use MakeTime and MakeDate together

Hi,

I need to load date which is less than specific date. here in date it has to be in 'YYYY-MM-DD hh:mm' format.

Here date is reload date and hh:mm is MakeTime(6,30).

MakeTime value is dynamic.

so how can i get

mydate < reloaddate in 'YYYY-MM-DD' and Maketime(6,30)

15 Replies
Anonymous
Not applicable

Try to compare into numeric like:

where num(date(Your field,'YYYY-MM-DD hh:mm:ss[.fff] TT'))) <num(date(ReloadTime() ,'YYYY-MM-DD') &'  '& time(MakeTime(6,3),'hh:mm'))

Hope this will help!!

anuradhaa
Partner - Creator II
Partner - Creator II
Author

hi I have used "num(date(ReloadTime() ,'YYYY-MM-DD') &'  '& time(MakeTime(6,3),'hh:mm'))" in text object and it shows "-"

Anonymous
Not applicable

Remove num() as its not working, need to see into it..

You can do like:

=date(ReloadTime(),'DD/MMM/YYYY')&' '&Time(MakeTime(6,30),'hh:mm')

Kushal_Chawda

try,

where

timestamp(YourDate,'YYYY-MM-DD hh:mm')<timestamp(date(floor(ReloadTime()) ,'YYYY-MM-DD') + time(MakeTime(6,30),'hh:mm'),'YYYY-MM-DD hh:mm')

jyothish8807
Master II
Master II

have you tried my solution?

Regards

KC

Best Regards,
KC
MarcoWedel

Hi,

one solution could be also:

myDate < Floor(ReloadTime())+'06:30'

QlikCommunity_Thread_190922_Pic1.JPG

hope this helps

regards

Marco