To calculate Yesterdays date(Timestamp).

[Subhasree]

Hi all,

Is there any function that can be used to calculate Yesterday's date of datatype Timestamp?

I tried giving CurrentTimestamp()-1 but when i compiled it shows the error as :

"Invalid conversion requested from a dfloat to a timestamp".

Actually i have to give constraint in the transformer as "X >= 'yesterday's date" where the column X is of datatype timestamp.
And also there is no iconv,oconv fucion in Parrallel Jobs.

Please help me in this regard.

Thanks in advance.

[ray.wurlod]

Explore the DateFromDaysSince() function.

[niranjansigeni]

Try this

In transfomer, in the column defination

DateFromJulianDay(JulianDayFromDate(CurrentDate)-1)


Thanks

Hi all,

Is there any function that can be used to calculate Yesterday's date of datatype Timestamp?

I tried giving CurrentTimestamp()-1 but when i compiled it shows the error as :

"Invalid conversion requested from a dfloat to a timestamp".

Actually i have to give constraint in the transformer as "X >= 'yesterday's date" where the column X is of datatype timestamp.
And also there is no iconv,oconv fucion in Parrallel Jobs.

Please help me in this regard.

Thanks in advance.

[niranjansigeni]

Try this

In transfomer, in the column defination

DateFromJulianDay(JulianDayFromDate(CurrentDate)-1)


Thanks

Hi all,

Is there any function that can be used to calculate Yesterday's date of datatype Timestamp?

I tried giving CurrentTimestamp()-1 but when i compiled it shows the error as :

"Invalid conversion requested from a dfloat to a timestamp".

Actually i have to give constraint in the transformer as "X >= 'yesterday's date" where the column X is of datatype timestamp.
And also there is no iconv,oconv fucion in Parrallel Jobs.

Please help me in this regard.

Thanks in advance.

[niranjansigeni]

Try this

In transfomer, in the column defination

DateFromJulianDay(JulianDayFromDate(CurrentDate)-1)


Thanks

Hi all,

Is there any function that can be used to calculate Yesterday's date of datatype Timestamp?

I tried giving CurrentTimestamp()-1 but when i compiled it shows the error as :

"Invalid conversion requested from a dfloat to a timestamp".

Actually i have to give constraint in the transformer as "X >= 'yesterday's date" where the column X is of datatype timestamp.
And also there is no iconv,oconv fucion in Parrallel Jobs.

Please help me in this regard.

Thanks in advance.