Load where greater than timestamp date issue

[#1]

Hi Experts

I'm loading a condtional map - see below .

What I need is when a process instance has field Prev_Activity_Description = 'Contact Customer' and State_Code='CMP' and Prev_TXN_Date > '01/12/2013 08:00:00';

The issue is when I try and put the date restriction in - its like it doesnt recognise the format ( But that is the format defaulted in the charts)

Can anyone advise how to rectify ?

Thanks

A

My_Map:

MAPPING LOAD Process_instance, 'SME' as Flag

RESIDENT lENDERS

where Prev_Activity_Description = 'Contact Customer' and State_Code='CMP' ;

[#2]

once I said it out loud I think I resolved it

where Prev_Activity_Description = 'Contact Customer' and State_Code='CMP' and date(date(Prev_Txn_Date)) > '01/12/2013' ;

Thanks
A

[Sokkorn · Accepted solution]

Hi Anne,

You may try this

and Prev_TXN_Date > Num(Date#('01/12/2013 08:00:00','MM/DD/YYYY hh:mm:ss'));

Regards,

Sokkorn