Can't get start date and end date value

CloverDX Platform
1

New in CloverDX. I created a Database reader connected to trash just to test if i can use variable date variables, my query below

select ‘${start_date}’ as start_date, ‘${end_date}’ as end_date

I’m using metadata
name
start_date string
end_date string

how come my output is just
${start_date} and ${end_date}

and not calling system date?

2

Hi Makeflo,

What exactly are you trying to achieve ? This construct ${…name…} in Clover is used to reference parameters, which are static values defined at transformation graph level - think of them as user defined constants.

I don’t understand, what do you mean by system date ?

David

3

Hi David, its all good now. my mistake is that there is no explicit values in Parameters.