Add 24 Hours to Sysdate
Content
I have the below formula that display Support No when the c$osp_end is the same day as the sysdate. What I'm trying to do so it would still be Support Yes when the c$osp_end is the same as the sysdate. Any ideas how to accomplish?
if((purchased_products.c$osp_status ='Not Cancld' | purchased_products.c$osp_status='Support on' | purchased_products.c$osp_status='REINST' | purchased_products.c$osp_status='NONE') & (purchased_products.c$osp_end>=sysdate()),'Support Yes', 'Support No')
Tagged:
0