Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
How to get current date records in Script level.
i have done like this condition.... where datefield>=today()
is anything wrong???
Id | Open date | Amount |
100 | 3/11/2015 | 100 |
101 | 3/11/2015 | 100 |
102 | 3/11/2015 | 200 |
103 | 3/11/2015 | 23 |
104 | 3/11/2015 | 45 |
105 | 3/11/2015 | 67 |
106 | 3/11/2015 | 90 |
107 | 3/11/2015 | 2 |
108 | 3/11/2015 | 6 |
109 | 3/11/2015 | 9 |
110 | 3/11/2015 | 10 |
111 | 3/11/2015 | |
112 | 3/11/2015 | 25 |
113 | 3/11/2015 | 50 |
114 | 3/11/2015 | 12 |
115 | 1/28/2015 | 23 |
116 | 1/29/2015 | 51 |
117 | 8/28/2013 | 80 |
118 | 9/1/2013 | 90 |
119 | 9/22/2013 | 9 |
120 | 9/30/2013 | 7 |
121 | 10/21/2013 | 12 |
122 | 10/29/2013 | 10 |
i want sow only today's date records only..... 3/11/2015
LOAD Id,
[Open date],
Amount
FROM
[http://community.qlik.com/thread/155752]
(html, codepage is 1252, embedded labels, table is @1)
where Floor(today())=floor([Open date]);
where Date#(datefield,'D/M/YYYY')=Date#(today(),'D/M/YYYY')
Have you tried where date#(datefield,'m/d/yyyy')<=today()?
Hi,
Try
SET vDate = date(today(),'DD/MM/YYYY');
LOAD * INLINE [
ID, Open Date, Amount
100, 3/11/2015, 100
101, 3/11/2015, 100
102, 3/11/2015, 200
103, 3/11/2015, 23
104, 3/11/2015, 45
105, 3/11/2015, 67
106, 3/11/2015, 90
107, 3/11/2015, 2
108, 3/11/2015, 6
109, 3/11/2015, 9
110, 3/11/2015, 10
111, 3/11/2015,
112, 3/11/2015, 25
113, 3/11/2015, 50
114, 3/11/2015, 12
115, 1/28/2015, 23
116, 1/29/2015, 51
117, 8/28/2013, 80
118, 9/1/2013, 90
119, 9/22/2013, 9
120, 9/30/2013, 7
121, 10/21/2013, 12
122, 10/29/2013, 10
]where [Open Date]<=$(vDate);
LOAD Id,
[Open date],
Amount
FROM
[http://community.qlik.com/thread/155752]
(html, codepage is 1252, embedded labels, table is @1)
where Floor(today())=floor([Open date]);
SET vDate = date(today()-1,'DD/MM/YYYY');
LOAD Id,
[Open date],
Amount
FROM
[SampleData.xlsx]
(ooxml, embedded labels, table is INDIA) where [Open date]>=$(vDate);
LOAD Id,
[Open date],
Amount
FROM
(ooxml, embedded labels, table is INDIA)
WHERE [Open date] = TODAY();
Hi All,
Thanks for Response..
Actually i have done same thing...
May be date format issue's.................
Anyway thank you All...............
Could be, does the date format of the source match the QVW, the dates in the example above are MM/DD/YYYY etc
Andy