Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to load data where expiration date is greater than today, when i load script it doesnt filter data above expiration date greater than today(). Below shows all data.
in my databse i have date in this format 2015-02-11 23:59:59
let varExpirationDate = Timestamp(Today(),'MM-DD-YYYY hh:mm:ss');
LOAD `campaign_id`,
`campaign_group_id`,
`start_date`,
expiration_date;
SQL SELECT `campaign_id`,
`start_date`,
`campaign_group_id`,
expiration_date,
FROM rcdb.CAMPAIGN where expiration_date >= '$(varExpirationDate)';
what am i missing?
Hi Supriya,
See the Date format.
databse format 2015-02-11 23:59:59
let varExpirationDate = Timestamp(Today(),'MM-DD-YYYY hh:mm:ss');
The variable Should be :
let varExpirationDate = Timestamp(Today(),'YYYY-MM-DD hh:mm:ss');
Hope this helps.
Thanks Nilesh,
For pointing out error in my code, i dint even realized it.
Sorry guys for your time.