got error message in excel "5 Invalid procedure call or argument". can any one explain
Greetings to All,
I need some doubts to be cleared regarding time generation of reports. I have attached here 2 excels.
in excel 1, reports are scheduled to run at 10Pm daily. now issue is lets say for report logs between 27.07.16-28.07.16 will be generating at at 29.07.16 which is wrong it should generate at 28.07.16. I know that I am doing something wrong with the start time & end time but I am not able to figure it out.
In 2nd excel I used simple start & end time using NOW() & NOW()-DAY("1"). But for this frmat i got some unique error at some places instead of values stating "5 Invalid procedure call or argument", which i never heard.
Can someone please help mme regarding this start & end time issue. My goal is to generate report for 27.07.16 to 28.07.16 consumption at 28.07.16 10pm
Thanks & regards
Insert the URL that your highlighted text will link to.
Copy the video's "embed" tag into Embedded Video below.