where condition

[smilingjohn]

Hi All,

I am using below sript and fetching the data from Data base

it executes the script with error saying doesn't match  the where condition

error msesage

Literal does not match format string

where "ServiceDate">'43118'

Please someone can suggest me how do i write the wehere condition . here

Load

ServiceDate,

Dept,

Text(Item) as Item_Key ,

Product,

State

SQL SELECT

* FROM  "DTS_IP".Fact

Where ServiceDate > '$(vLast_Update_Date)';

Need help

Thanks in advance

[shiveshsingh]

Hi

Try this

Load

ServiceDate,

Dept,

Text(Item) as Item_Key ,

Product,

State;

SQL SELECT

ServiceDate,

Dept,

Item,

Product

FROM  "DTS_IP".Fact

Where ServiceDate > '$(vLast_Update_Date)';

[olivierrobin · Accepted solution]

hello

as usual with dates, you have to take care or the format or date fields

be sure that your field and the content of the variable have same date format

[smilingjohn]

HI Shivesh ,

Thanks for the reply it says

Literal does not match format string

where "ServiceDate">'43118'

[smilingjohn]

Hi Robin,

The date format is same it is giving the below error message during the reload process as

Literal does not match format string

where "ServiceDate">'43118'

thanks

[smilingjohn]

Hi Robin

Yes you are correct it is issue with the date format

Thanks

[shiveshsingh]

Then you need to check the format of the date