need help

[antonybi]

Hi Folks,

I have two date columns with timestamp called closed date('DD-MM-YY hh:mm:ss tt') and deadline date('DD-MM-YY hh:mm:ss tt')

Now I have to create two flags
If ([closed date]<[deadline date],1,0) as flag1
If ([closed date]>[deadline date],1,0) as flag2

but not getting accurate results.

whats wrong with this.?

Pls help as so needful.

[vishalarote]

can you please share your qvw file and data source file ?

[jyothish8807 · Accepted solution]

Hi Antony,

Try like this:

If (timestamp(timestamp#([created date],'DD-MM-YY hh:mm:ss tt'))<timestamp(timestamp#([deadline date],'DD-MM-YY hh:mm:ss tt')),1,0) as flag1

If (timestamp(timestamp#([created date],'DD-MM-YY hh:mm:ss tt'))>timestamp(timestamp#([deadline date],'DD-MM-YY hh:mm:ss tt')),1,0) as flag2

Br,

KC

[antonybi]

actually am working on real data.

I have to create two flags based on these conditions.

– if the ticket is closed (Closed Date) before the deadline date

– if the ticket is closed (Closed Date) after the deadline date

am not getting accurate results because of timestamp.

How to handle this??

[antonybi]

Hi Jyothish,

I tried the same but still no luck.

[jyothish8807]

CAn you share a sample format of the date fields you are loading ?

Also can you share your script ?

Br,

KC

[antonybi]

Hi Jyothish,

I have removed timestamp# in your expression. Now it  is working perfectly.

Thank u!

[jyothish8807]

Cool