Comparing date fields
Posted: Wed Dec 17, 2008 1:21 am
Hi all,
I am facing an issue when comparing date fields.
I am doing like this
If Lkp_Read.EFF_DT_Target=Lkp_Read.EFF_DT_Input then 'I' Else 'U'
Lkp_Read.EFF_DT_Target,Lkp_Read.EFF_DT_Input are two nullable date fields.
If null is coming its giving warning as
Tfm_2,0: Conversion error calling conversion routine date_from_ustring data may have been lost
i tried using NULLToValue function also for assigning '' to date field but its not assigning empty to date field.
Please help me in this one
Thanks for your help
Regards
Swathi S
I am facing an issue when comparing date fields.
I am doing like this
If Lkp_Read.EFF_DT_Target=Lkp_Read.EFF_DT_Input then 'I' Else 'U'
Lkp_Read.EFF_DT_Target,Lkp_Read.EFF_DT_Input are two nullable date fields.
If null is coming its giving warning as
Tfm_2,0: Conversion error calling conversion routine date_from_ustring data may have been lost
i tried using NULLToValue function also for assigning '' to date field but its not assigning empty to date field.
Please help me in this one
Thanks for your help
Regards
Swathi S