
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)
- Tags:
- new_to_qlikview
- « Previous Replies
-
- 1
- 2
- Next Replies »

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Do you want to create this MYDate field or you already have this?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I already have that

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
will this work?
like:
load
date(MyDateField,'YYYY-MM-DD') as MyDateField
From tablename where num(MyDateField)<=num(reloaddate)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Making time from your MyDateField seems tough..
For that I guess you need to go for looping to make time field...

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
what is the format of Your date?


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Anuradha,
Try like this:
load
date(Your field,'YYYY-MM-DD h:mm:ss[.fff] TT')) as Yourfield,
reloaddate
from <>
where date(Your field,'YYYY-MM-DD h:mm:ss[.fff] TT')) < reloaddate;
Hope it helps
Regards
KC
KC

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
YYYY-MM-DD hh:mi:ss

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
No, I want to dinamicaly calculate that date i want to use in where clause.
Get Date from reload date and time from my expression.
I know how to calculate that time.
But i don't know how to join that date and time inside where clause.
Say my time is 06:30 and date is 2015-11-09
i want to use
myDate < 2015-11-09 06:30 in where clause


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
And yes, if reload time is combination of two fields then please combine them and make one field and use in script.
Load
date(Your field,'YYYY-MM-DD h:mm:ss[.fff] TT')) as Yourfield,
date(ReloadTime() ,'YYYY-MM-DD') &' '& MakeTime(6,3) as reloaddate
where date(Your field,'YYYY-MM-DD h:mm:ss[.fff] TT')) <date(ReloadTime() ,'YYYY-MM-DD') &' '& MakeTime(6,3)
Regards
KC
KC

- « Previous Replies
-
- 1
- 2
- Next Replies »