Date Calculation
Can anyone help me in this calculation Need to calculate Current Date + No. of Days in a Month. We have process to create automated ticket in Remedy, so when a ticket is created the End Date of the ticket should be Month End Date. Example: If a Ticket created in Current Date is 7/05/2014 12:00:00 AM and the End Date should have 31/05/2014 11:59:59 PM. Kindly provide your suggestion on this. Regards, Karthick S ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Set Month End Date
Wouldn't the calculation of 32 days cause it to possibly jump over a month? ie if the ticket is created on March 31 (or even March 30) it would calcuate a date in May. Rather than try to play with the days - could we do something like this? Set Fields actions (in Filter or Active Link) Action 1:$ztmp datetime field$ = DATEADD(mm, 1, $DATE$) Action 2:$ztmp datetime field$ = MONTH($ztmp datetime field$) + /1/ + YEAR($ztmp datetime field) Action 3:$ztmp datetime field$ = $ztmp datetime field$ - 1 - Original Message - From: Frederick W Grooms frederick.w.gro...@xo.com To: arslist@ARSLIST.ORG Sent: Wednesday, May 7, 2014 11:35:12 AM Subject: Re: Set Month End Date This is the way I have done it in the past (Note: I am using US date format so convert as needed) Set Fields actions (in Filter or Active Link) Action 1:$ztmp string field$ = MONTH($DATE$) + /1/ + YEAR($DATE) Action 2:$ztmp datetime field$ = $ztmp string field$ Action 3:$ztmp datetime field$ = $ztmp datetime field$ + (32 * 86400) Action 4:$ztmp string field$ = MONTH($ztmp datetime field$) + /1/ + YEAR($ztmp datetime field) Action 5:$ztmp datetime field$ = $ztmp string field$ Action 6:$ztmp datetime field$ = $ztmp datetime field$ - 1 At this point the display only datetime field has 11:59:59 PM of the last day of the month I broke the example out into individual set fields actions so you can see exactly what is happening. Here is what each action is doing: Action 1: Create a string of the first day of the current month Action 2: Put the string into a date field Action 3: Add enough days to make the temp field the next month Action 4: Create a string of the first day of the month of the temp date field Action 5: Put the string into a date field Action 6: Subtract 1 second from the temporary date field to get the last day of the previous month Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Terje Moglestue Sent: Wednesday, May 07, 2014 7:37 AM To: arslist@ARSLIST.ORG Subject: Re: Set Month End Date ** Karthick, It is years since I have done this type of calculations. In your example I would find the first day of the next month and then just take minus one day. The outcome would the last day of the month you are in. ~ Terje -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Karthick S Sent: Wednesday, May 07, 2014 8:50 AM To: arslist@ARSLIST.ORG Subject: Set Month End Date ** I need to Set a Month End Date in a field Called Due Date. Please find the below. Example: Ticket created Date is 7/05/2014 12:00:00 AM and the Due Date should have 31/05/2014 11:59:59 PM. it should automatically calculate or populate the Month End Date in Due Date field. I have used this condition ($DATE$ + 43200) + (86400 * 31)) - (86400 * DAY((($DATE$ + 43200) + (31 * 86400) - (3600 * HOUR((($DATE$ + 43200) + (31 * 86400) + (DAY($DATE$) * 86400)) - 1, Which given me the Due Date as 7/06/2014 11:59:00 PM. Can any one help me on this, Please. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
How to change ip-addresses for Remedy servers.
Hi, everyone We need to change ip-addresses for our Remedy servers (BMC Remedy ITSM 7.6, operation system Windows 2008R2). Our current environment includes - web, application and database servers. Step 1. I change address on web-server. After I configure (add new ip-address) in SSO Admin Console it works correctly. Step 2. I change address on application-server. After this, windows service - BMC Remedy Action Request System Server doesn't start... There is error The description for Event ID 0 from source AR System Monitor cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer. in Event Viewer. What should I do to start Remedy correctly? In general, Is it possible? I mean - changing ip-address on application server. Thanks in advance, Andrey. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Set Month End Date
The DateNum function is your friend here, try this Have a temp character field and set it to be: Temp Character = (DATENUM(mm, $DATE$) +1) + /1/) + YEAR($TIMESTAMP$) (You may have to reformat this a bit depending on Locale) Then have another set fields into a temp date field that does Temp Date = $Temp Character$ Then one more that does DueDate = $Temp Date$ - 1 I haven't tested this but it should work From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Karthick S Sent: Wednesday, May 07, 2014 3:50 AM To: arslist@ARSLIST.ORG Subject: Set Month End Date ** I need to Set a Month End Date in a field Called Due Date. Please find the below. Example: Ticket created Date is 7/05/2014 12:00:00 AM and the Due Date should have 31/05/2014 11:59:59 PM. it should automatically calculate or populate the Month End Date in Due Date field. I have used this condition ($DATE$ + 43200) + (86400 * 31)) - (86400 * DAY((($DATE$ + 43200) + (31 * 86400) - (3600 * HOUR((($DATE$ + 43200) + (31 * 86400) + (DAY($DATE$) * 86400)) - 1, Which given me the Due Date as 7/06/2014 11:59:00 PM. Can any one help me on this, Please. _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: [EXTERNAL] Re: Analytics report - difference in Summary and Detail sheet.
Harry: What kind of table appears on the Detail page, and is it a standard table or a crosstab? On crosstab tables that show, say, one row for (in your case) open changes and, say, one row for closed changes, if you don't create a merged dimension for both a date from the open changes and a date from the closed changes, I have seen results like what you describe. Thanks, Natalie Stroud ITSM Reporting Specialist SAIC for Sandia National Laboratories Albuquerque, NM USA nkst...@sandia.gov From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of Harry [amrutharida...@gmail.com] Sent: Monday, May 05, 2014 11:23 PM To: arslist@ARSLIST.ORG Subject: [EXTERNAL] Re: Analytics report - difference in Summary and Detail sheet. ** Its Analytics for BSM 7.6.06 SAP Business Objects (BO)-BO 4.0 SP04 Thanks Harry On Tuesday, May 6, 2014 12:13:35 AM UTC-5, Harry wrote: ** Hi Experts, Why would be there difference in pie-chart- summary xls sheet and its Change requests -in tabular format /Detail xls sheet ? Is there something broken ? Thanks, Harry _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Exporting query into csv excell worksheet
Hi, We have a similar macro running on server. We don't need to append to existing file but create a new file will date; but you can use the concept. Insert the macro into a wrapper. A filter run process executes a script on the server, that script executes the run macro, once the report is exported, its is renamed to with date. This report runs once a day. we are on unix, so scripting is downdirty. In your case, Once the report is export, append it the original, and delete. -- View this message in context: http://ars-action-request-system.1.n7.nabble.com/Exporting-query-into-csv-excell-worksheet-tp116955p117010.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
8.1.01.001 Patches -- Issue
Ran into a issue this week and here is the problem and resolution Problem :: ARS 8.1.01 -- attempting to apply ARS patch 001 and it will not work.. it says no product selected and fails. It worked on another system... The P001 SRM, and Atrium did work... however Solution:: ENV variable not in system -- BMC_AR_SYSTEM_HOME = PATH-TO-ARSYSTEM folder Patch runs... Potential Fix action if this does not work:: Copy ARSystemInstalledConfiguration.xml file from a working server and replace same file on the non-working server. Modify the file with the correct server name entries. Rerun the installation. -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Date Calculation
Hi, First you find the start point of the month: MonthStart = DATEADD(dd, 1 - DAY($DATE$), $DATE$) Then you find the first of the next month and subtract one second: MonthEnd = DATEADD(mm, 1, $MonthStart$) - 1 And you can do this in a single step: DATEADD(mm, 1, DATEADD(dd, 1 - DAY($DATE$), $DATE$)) - 1 Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Can anyone help me in this calculation Need to calculate Current Date + No. of Days in a Month. We have process to create automated ticket in Remedy, so when a ticket is created the End Date of the ticket should be Month End Date. Example: If a Ticket created in Current Date is 7/05/2014 12:00:00 AM and the End Date should have 31/05/2014 11:59:59 PM. Kindly provide your suggestion on this. Regards, Karthick S ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Transactional (TR) and Database (DB)
Hi List, We can achieve things without using TR and DB values in a filter by just using Field but I do not understand why they have been developed to use? I have heard from many remedy developers like Misi and BMC who suggest not to use TR and DB in Run If qualification of a filter but why? Why it is not recommended to use TR and DB values? What if I use TR.Field=DB.Field? Will it yield a correct result? In BMC documentation also they have not given any example where they used TR and DB together in a qualification. Appreciate your thoughts! Cheers, James ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years