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
probably your problem depends on your local language setting.
In control panel you have defined your Region and Language format.
In Excel on your Cell you can define Format Cell, and in Custom you see which different strings that are possible to use.
Your Start time can be defined as eg =CONCATENATE(TEXT(NOW()-1;"YYYY-MM-DD");" 00:00") if YYYY MM and DD are available and you want to start at midnight.