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???
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]);
View solution in original post
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);
SET vDate = date(today()-1,'DD/MM/YYYY');
[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();
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
