yesterday date without time.

[esanray]

how to get yesterday's date without the time in report studio?

[Steve]

Create a Query calculation and insert this:

_add_days(current_date,-1)

[esanray]

Yes I try this last week but the problem is that when I run the report on 7th April  it display the correct  date that is 6th April( Yesterday Date) but when I run the report today this 11 april this report show me the 6th april date.

My requirement is that when I run the report it show the previous day.

[PRIT AMRIT]

when I run the report today this 11 april this report show me the 6th april date

Strange though, ensure what current_date is returning first?

[jahnavi]

I think There are two date columns in your query . Maku sure current date will be the first one

[esanray]

no , any other Suggestion or any other process

[CommandoCognos]

Maybe the report is in the Cognos/DB cache. You could prevent that by setting "Use Local Cache" to "No".

hth