Regardin NetWorkDays() function

[sarfaraz_sheikh]

Hi All,

I want to calculate the diffrence of days between receive_date and  create_date_system ....suppose for ex.

Receive_date = 18-OCT-2014    and

Create_date_system = 20-OCT-2014

Result = 2    

i.e i should get 2 as result  and to achieve  this i used NetWorkDays(Receive_date ,Create_Date_System) function as well but still i am not getting as expected output ..nothing is appearing in the result column;;

below is my data: help me for needful solution 

Inward_No ,  Create_Date , Receive_Date,   Create_Date_System

IN1747446, 14-OCT-10, 14-OCT-10,  15-OCT-10,
IN1747505, 14-OCT-10, 15-OCT-10,  16-OCT-10,
IN1747462, 14-OCT-10, 14-OCT-10,  17-OCT-10,
IN1749635, 14-OCT-10, 14-OCT-10,  17-OCT-10,
IN1749685, 14-OCT-10, 15-OCT-10,  16-OCT-10,
IN1750030, 14-OCT-10, 14-OCT-10,  14-OCT-10,
IN1750844, 14-OCT-10, 16-OCT-10,  18-OCT-10,
IN1750852, 14-OCT-10, 14-OCT-10,  14-OCT-10,
IN1751131, 14-OCT-10, 14-OCT-10,  16-OCT-10,
IN1751225, 14-OCT-10, 17-OCT-10,  14-OCT-10,
IN1747596, 14-OCT-10, 14-OCT-10,  16-OCT-10,
IN1749671, 14-OCT-10, 18-OCT-10,  20-OCT-10,
IN1747512, 14-OCT-10, 14-OCT-10,  14-OCT-10,
IN1750063, 14-OCT-10, 19-OCT-10,  21-OCT-10,
IN1749916, 14-OCT-10, 20-OCT-10,  14-OCT-10,
IN1750267, 14-OCT-10, 14-OCT-10,  14-OCT-10,
IN4423581, 14-OCT-11, 21-OCT-11,  23-OCT-11,

Regards

Sarfaraz Sheikh

[ashwanin]

Hi Sarfaraz,

Date format in the above example is not as DD-MMM-YY. It seems, but in actual it doesn't.

Once you get it corrected the Networkdays formula automatically will work.

See attached QVW with your date format as mentioned above and in correct format.