• RELEVANCY SCORE 4.20

    DB:4.20:Push Field To Create Date Field. cj




    I am in the process of migrating all Legacy Task records from ITSM 6 to ITSM 7. As part of my push into the TMS:TASK form, I have to keep the original Create Date value. My only problem is that the create date field is not available for me to select, for my Push Field Action. Should I be using another form to import the Task Legacy records?

    DB:4.20:Push Field To Create Date Field. cj


    Hi Osolaru,

    Are you tring to import records in to new version?

    or are you trying to use workflow to push values using a AL or Filter to push values ?

    I think it is lot easier to export and import data instead of writing workflow for it.

    HTH

    Venkat

  • RELEVANCY SCORE 3.96

    DB:3.96:Date Field ca





    HI All,

    How to create date field?

    DB:3.96:Date Field ca


    Please check Henric's blog post:

    http://community.qlik.com/blogs/qlikviewdesignblog/2012/06/07/get-the-dates-right

    resp.

    http://community.qlik.com/docs/DOC-3102

    Regards,

    Stefan

  • RELEVANCY SCORE 3.82

    DB:3.82:Want To Create An Autofill/Auto Populate Field For Expired Date s3




    Hello,
    I am a beginner to Access 2010. Can someone help me out? I would like my expired date field automatic popuplated in the fillform, query , and report after I enter the warranty year.

    Purchased date field (date/time) field
    warranty (integer) field
    Warranty expired date (date/time) field
    Thank you

    DB:3.82:Want To Create An Autofill/Auto Populate Field For Expired Date s3

    Yes, it is! warranty is in year. Thank you very much NadiaSz.

  • RELEVANCY SCORE 3.70

    DB:3.70:Calculated Field In Adf Form f7


    I want to create calculated field.
    I have 2 date fields, my user case is to calculate difference between those 2 date field and display difference on the fly to user.

    DB:3.70:Calculated Field In Adf Form f7

    You will need to write custom logic in a method of a managed Bean in your View Controller project.
    follow these steps -

    1)In the ViewController project ,create a java Class called whatever_name_you want.java
    2) register the managedBean in TaskFlow-Overview- Managed Bean say in pageFlowScope.
    3)create a public method which returns a Number (of days or whatever you need) in your bean which calculates difference between the dates using Calender API (You can google for this)
    4)Bind this method to the value property of the field which shows the difference between these fields.

  • RELEVANCY SCORE 3.65

    DB:3.65:Localization The Date Field d1


    hii want to change date field is there a way?

    DB:3.65:Localization The Date Field d1

    Localisation can be controlled at system level or per-use.To set the system locale, use the System Properties application (there's no web applet) and choose the time zone. This sets all the locale displays including daylight savings. It can also be customised if desired.For users, they can override their personal locale from the "My Profile" page.For scripting purposes, try reading this: WebMonkeyMagic: Comparing Dates and Time Zones

  • RELEVANCY SCORE 3.63

    DB:3.63:Datetime Value Is Not Getting Inserted Properly In Remedy Datetime Field Through Bao? pf



    Hi All,

    I'm trying to create Incident record through BAO when I push value for 'Reported Date' field i'm getting weird results.

    If I pass on value as : 1/1/2015 11:00:40 PM

    then it's throwing Remedy Exception as: The Value 1/1/2015 11:00:40 PM for field: xxxxxxxx is not the correct DatType, Expecting 'Time'.

    If I pass on value as epoch date: 1420113600000 (which is 01/01/2015 12:00:00)

    but it is setting the value as: 1/1/1970 5:30:00 AM

    Anyone experienced this, kindly help me over this.

    Thanks,

    Dnyaneshwar

  • RELEVANCY SCORE 3.57

    DB:3.57:Moss 2007 - Todays Date Field mp


    I am trying to create a 'todays date' field within MOSS 2007 within a custom table. I need this date to change daily (may seem obvious) so that I can then perform additional calculations from this field. Is there anybody out there that is able to help?

    Many thanks.

    DB:3.57:Moss 2007 - Todays Date Field mp


    For issues related to Microsoft SharePoint server, post your queries in the link below:
    http://social.technet.microsoft.com/Forums/en-us/category/sharepoint

  • RELEVANCY SCORE 3.53

    DB:3.53:Round Up Date Field To Year End sp


    Hi all,
    I need to create a date field, from another date field that will display the end of the year. Ex. if Date Field1 is 3/4/11, then Date Field 2 is 12/31/11.
    I was playing with the Calculated Value in Date Field 2 to try to get the end of the year value for Date Field 1, but am stuck. Anyone have a formula or suggestion (=YEAREND would be awesome ;-)
    Thanks,
    K
    My Company Blog: http://blog.concurrency.com/author/krusk

    My Personal Blog:http://thebitsthatbyte.com

    DB:3.53:Round Up Date Field To Year End sp

    Got it working!!!
    Apparently, it will work as a Calculated Field set to a Date Field, but not a Calculated Value within a Date field.
    Thanks.My Company Blog: http://blog.concurrency.com/author/krusk

    My Personal Blog:http://thebitsthatbyte.com

  • RELEVANCY SCORE 3.52

    DB:3.52:Trying To Create A Date Field From Others Selecting The Newest Date mj



    In the DB data table there are a number of date fields,each representing a date action. I would like to create a 'final date field' that picks the newest date from those date fields, by row. If I was using excel I would use =IF(SUM(H2:K2)=0,"",MAX(H2:K2)).

    Next I would like to create another column that calculates the length of time from when a record was created against the 'final date field'. The created record field is timestamped but the others do not seem to be.

  • RELEVANCY SCORE 3.49

    DB:3.49:Field Validation z9


    Guys,

    I have a requirement where in I would be required to create a validation on a text field to only accept value in the format of a date/time field.

    Has any one come across a syntax which i can input on the field validation for a text field to accept the format of a date/time field. No other value should be accepted

    Nick

    DB:3.49:Field Validation z9

    You may need a little more testing to make sure because, if I remember correctly, date timestamp are saved as server time, not local time. If so, what's displayed should not effect anything.

    If not so, I would try to display the two date time fields for data entry and hide the two text fields for your workflow trigger. Populate the text fields with default value and workflows.

    Or better yet, just display the Deadline field (the date time field) and hide the Current Time (another date field or text field, matters not), which could be initialized by post default and updated by your web service piece.

  • RELEVANCY SCORE 3.44

    DB:3.44:Date Selection Field 9d



    Can I add a date selection field?

  • RELEVANCY SCORE 3.44

    DB:3.44:Issue To Create A Request At Form Out Of The Box ss



    I have a problem when create a request, i see the log in web, the action PUSH FIELD IS CORRECT BUT WHEN SEARCH THE REQUEST AT FORM DOES NOT EXIST

    THIS IS THE FLOW AND THE LOG

    ActiveLink: GOIT:FPS:LlamaGuia_CrearFPS

    True actions:

    action 0

    ARACTCallGuide(@, GIT:FPS:WFW_CrearFPS, false, undefined, undefined)

    ActiveLink: GOIT:FPS:WFW:Btn_Modificar_2

    True actions:

    action 0

    action 1

    Set-fields 536871089 = Si

    ActiveLink: GIT:FPS:WFW:Bandera_CreaFPS

    True actions:

    action 0

    Push-fields 2 = usuario.goit

    Push-fields 4 =

    Push-fields 7 = 0

    Push-fields 8 = 13/09/2013 04:36:31 p.m.

    Push-fields 260000001 = SEDE

    Push-fields 536870916 = 13/09/2013

    Push-fields 536870917 = SEN-868

    Push-fields 536870918 = .

    Push-fields 536870920 = .

    Push-fields 536870921 = .

    Push-fields 536870922 = .

    Push-fields 536870923 = .

    Push-fields 536870924 = INSURGENTES SUR 890, COLONIA DEL VALLE

    Push-fields 536870925 = Piso: 1 -- TIPO 11

    Push-fields 536870926 = INSURGENTES SUR 890

    Push-fields 536870927 = 13/09/2013

    Push-fields 536870928 = RESPONSABLE DE AREA DE APOYO INFORMATICO

    Push-fields 536870929 = SENER

    Push-fields 536870930 = OFICINA DEL SECRETARIO

    Push-fields 536870931 = 2260

    Push-fields 536870932 = 50006000

    Push-fields 536870933 = SEDE

    Push-fields 536870934 = OI-C7A2724713C44627AF924DCDBF214D99

    Push-fields 536870935 =

    Push-fields 536870936 = SENER

    Push-fields 536870939 = .

    Push-fields 536870942 = 100

    Push-fields 536870943 = .

    Push-fields 536870944 = 17

    Push-fields 536870945 =

    Push-fields 536870946 = .

    Push-fields 536870947 = .

    Push-fields 536870949 = 13142

    action 1

    ARACTCommit()

    ActiveLink: GIT:FPS:WFW:ActivarPedido

    False actions:

    ActiveLink: GIT:FPS:WFW:DesactivarRuta

    True actions:

    action 0

    ARACTSetVisibility(536870937, 0)

    ActiveLink: GIT:FPS:WFW:DesactivarPedido

    False actions:

    ActiveLink: GIT:FPS:WFW:ActivarImprimir

    True actions:

    action 0

    ARACTSetAccess(536870978, 2)

    action 2

    ARACTOpenReportWindow(ds-bmcremedy, GIT:FUERPS, , New, 9, [object Object], 1, 0, , [object Object],null,null,GIT:FPS:WFW:Btn_ImprimirRSENER, 2, [Timestamp=1379009811])

    ActiveLink: GIT:FPS:WFW:Btn_ImprimirSAT

    False actions:

    ActiveLink: GIT:FPS:WFW:Btn_ImprimirSCT

    False actions:

    ActiveLink: GIT:FPS:WFW:Btn_ImprimirGuardar

    False actions:

    DB:3.44:Issue To Create A Request At Form Out Of The Box ss


    Thanks,,

    ALready crate a validation trough a set field and temporally field, so when teh temporally field is "Yes" the error appears

  • RELEVANCY SCORE 3.44

    DB:3.44:Crm 2011: Update Field Value When Specific Date Is Reached zf


    Hi all,
    i have a requirement where I need to update a field value when the current date = date field value - 15 days
    So I was thinking about to create a hidden field an d to set its value to:date field value - 15 days in the onChange event ofdate field value and to create a workflow with a wait conditionuntil the dummy field date is reache
    then the update the required field
    Is this the best way to achieve my requirements or is there a better way ?
    Thanks and best regards...

    DB:3.44:Crm 2011: Update Field Value When Specific Date Is Reached zf

    Hi, I have found that it can be done using workflow wait condition directly without the need of a dummy field:

    I didn't test it yet, but I think it will be a better solution

    Best regards..

  • RELEVANCY SCORE 3.43

    DB:3.43:How Can I Create An Index On The Date Part Of A Timestamp Field? j7


    is there a way I can create an index on the date part of a timestamp field?

  • RELEVANCY SCORE 3.37

    DB:3.37:Due Date Field. 88



    hi gurus!

    i want to knw due date field for invoice.

    regards,

    Rahul

    DB:3.37:Due Date Field. 88


    may be it may help u

    bsik-zfbdt, " Base Line Date

    bsik-zbd1t, " Due date1

    bsik-zbd2t, " Due Date2

    bsik-zbd3t,

  • RELEVANCY SCORE 3.36

    DB:3.36:Week Extract From Date Field ? 7j



    Hi

    Please find attached the excel file.

    I have DATE field. I need to create PERIOD and WEEK (52 weeks) dimensions. Can someone tell me the logic?

    Many thanks

    DB:3.36:Week Extract From Date Field ? 7j


    Pls check the date format you are passing in week() function.it should be in following format

    e.g week( '1971-10-30' ) returns 43.

  • RELEVANCY SCORE 3.36

    DB:3.36:Html Db Validate Date Field 98


    I create a nondatabase date field (date picker (MM/DD/YYYY) and format mat as MM/DD/YYYY. I want to validate this date field to make sure the entry is valid. mm/DD/YYYY.
    I create a validation for the field, but it did not display the error message in the validation, instead it complains that the character is in numeric field with an OK button.

    Why?

    Is there a Is_date function around?

    DB:3.36:Html Db Validate Date Field 98

    Hm, you are right. A simple assignment would work just as well. Thanks for pointing that out.

  • RELEVANCY SCORE 3.32

    DB:3.32:"Date Validation" In A Rules File jm


    Can I to create a validation for a field for date type or some way to put conditions for inputs of data in a field inside a rules file?Thanks.

    DB:3.32:"Date Validation" In A Rules File jm

    Can I to create a validation for a field for date type or some way to put conditions for inputs of data in a field inside a rules file?Thanks.

  • RELEVANCY SCORE 3.31

    DB:3.31:Help With Code: Date Field From One Entity Populating Date Field Of Another Entity dz


    Wondering if someone could assist me in how to set a date value in one entity to the date value in another. Im pretty sure I know how to get the date of Entity A but im not sure how to push it to Entity B on change of entity A.

    DB:3.31:Help With Code: Date Field From One Entity Populating Date Field Of Another Entity dz

    To resolve this issue I created a workflow that will update the field on the account form when the date is changed on a custom entity.

  • RELEVANCY SCORE 3.30

    DB:3.30:Validate Dateofbirth Field 8z


    Hi Expert,I want to enhance create personal info screen , by add validation on date of birth field , so please how can do it ???thanks in advance.

    DB:3.30:Validate Dateofbirth Field 8z

    Thanks Shanyou mean I couldnt do it in spro ??so I have to implement enhancement using program exit?

  • RELEVANCY SCORE 3.29

    DB:3.29:Custom Field Rule On Work Item State Change fz


    Hi,
    I have custom field Due Date in my template and I would like to change value of this field during some transition. I know that I can create some field rule (eg. COPY) that assign some value to my field. Is it possible to use custom code to generate that
    value? I would like to assign my Due Date to something like: DateTime.Now.AddDays(7)

    DB:3.29:Custom Field Rule On Work Item State Change fz

    Hi Rosiek,

    Thanks for your reply.

    It seems there’s no other ways to do that. For this scenario, I suggest you submit it as a suggestion to User Voice site at:
    http://visualstudio.uservoice.com/forums/121579-visual-studio. Microsoft engineers will evaluate them seriously.John Qiao [MSFT]
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

  • RELEVANCY SCORE 3.29

    DB:3.29:Month Year Field pm



    Hi,

    i have a date field in the format of dd/mm/yyyy.

    i want to create another field which uses the date field to get it in the format of mm/yyyy, so i can use it as a dimension on a graph.

    What is the qlikview code to do this?

    Thanks

    Laura

    DB:3.29:Month Year Field pm


    Hi Laura,

    Try this script Date(makedate(year(today()),month(today()),Day(today())),'MMM/YYYY')

    Regards ,

    Perumal A

  • RELEVANCY SCORE 3.28

    DB:3.28:Discoverer: Conditional Format For A Date Field d3


    Hi there,

    just a simple newbie question:

    in my worksheet I have a simple date field. Now I want to create a conditional format for that date field that shows the fields with the current date in red.

    I tried Date Field = sysdate or Date Field = current_date but it doesn't work.

    Can someone help me please?

    Thank you!

    Micha

    DB:3.28:Discoverer: Conditional Format For A Date Field d3

    Hi

    Create a new column with sysdate expression and use this column in the conditinal filtering.

    Ott Karesz
    http://www.trendo-kft.hu

  • RELEVANCY SCORE 3.27

    DB:3.27:Datetime Field Doesnt Auto Update In Outlook Template 1d


    I have created an outlook 2010 template that contains the date/time field and I have the ‘update automatically’ field checked. The first message of the day created using the template does not auto update the date/time field to the current date, however,
    if I keep this first message open and create subsequent messages using the same template the date/time field is auto updated to reflect today’s date. I have tried using the 'CreateDate' field but the same thing happens.
    The message contains information relative to the date so it must show the correct date before being sent. We are currently manually updating the field, but this is not ideal as I have multiple users using these files, can anyone provide a possible fix
    for this?

    DB:3.27:Datetime Field Doesnt Auto Update In Outlook Template 1d

    I've tried contacting Microsoft about the error, but I got the run around... Wish there was an easy way to submit a software problem.

  • RELEVANCY SCORE 3.26

    DB:3.26:Create Pushbutton. zd



    Hi,

    Is it possible to create push button for a field in table view in SAO CRM WEBUI?

    Suppose tableview contains the fields Action, Cat Description, Date.

    Now I want to put pushbutton for "Action" field for all the records in the table view.

    Is it POssible.

    Regards,

    DB:3.26:Create Pushbutton. zd


    Hi Manfred,

    For this code some other button is coming. But I need only Push Buttons.

    Regards,

    Pushpa

  • RELEVANCY SCORE 3.26

    DB:3.26:Push Puttons And Input Fields xz



    Hello,

    How can I create a push putton and an input field in SAP?

    DB:3.26:Push Puttons And Input Fields xz


    Incase you need to create in a normal report program, you can check below example:
    PARAMETERS: p_text TYPE char20.

    SELECTION-SCREEN BEGIN OF LINE.
    SELECTION-SCREEN PUSHBUTTON 5(10) but USER-COMMAND com.
    SELECTION-SCREEN END OF LINE.

    INITIALIZATION.
    MOVE 'Button' TO but.

  • RELEVANCY SCORE 3.26

    DB:3.26:Dynamic Date Selection dc



    Hello Everyone,

    Im trying to create a variant with a dynamic date where the first date field will be blank and the second date field will be equal to today's date.

    Example........." " to 04/12/2012. I can't seem to find an option that will allow the first field to be blank. Can someone please help!?

    James

    DB:3.26:Dynamic Date Selection dc


    I see. With the existing dynamic selection options, I do not believe you can do it. You can only make the first field less equal current date.

  • RELEVANCY SCORE 3.25

    DB:3.25:Sos: Javax.Ejb.Createexception: Create Failed Because Primary Key Is Null ck


    Hello,

    I am desperately trying to get my application server to create a record through CMP 2. My app server is JRun 4.

    Here is the client:
    package com.parispano.tests;

    import java.util.Date;
    import java.util.Properties;

    import javax.naming.Context;
    import javax.naming.InitialContext;

    import com.parispano.account.entity.Account;
    import com.parispano.account.entity.AccountHome;

    public class ClientEJBDeuxTemp {

    public static void main(String[] args) {

    System.out.println("\nBegin account DemoClient...\n");

    try {
    // Create A Demo object, in the server
    // Note: the name of the class corresponds to the JNDI
    // property declared in the DeploymentDescriptor
    // From DeploymentDescriptor ...
    // beanHomeName demo.DemoHome

    Context ctx = getInitialContext();
    AccountHome ahome = (AccountHome) ctx.lookup("AccountEJBHome");

    //System.out.println("Creating Demo\n");
    Account account = ahome.create("toto","toto", "toto","toto","toto","toto","toto","toto","toto","toto","toto",new Date(),new Date());

    }
    catch (Exception e) {
    System.out.println(":::::::::::::: Error :::::::::::::::::");
    e.printStackTrace();
    }
    System.out.println("\nEnd DemoClient...\n");
    }

    static String user = "admin";
    static String password = "admin";
    static String url = "ordi:2908";


    /**
    * Gets an initial context.
    *
    * @return Context
    * @exception java.lang.Exception if there is
    * an error in getting a Context
    */
    static public Context getInitialContext() throws Exception {
    Properties p = new Properties();
    p.put(Context.INITIAL_CONTEXT_FACTORY, "jrun.naming.JRunContextFactory");
    p.put(Context.PROVIDER_URL, url);
    if (user != null) {
    System.out.println ("user: " + user);
    p.put(Context.SECURITY_PRINCIPAL, user);
    if (password == null)
    password = "";
    p.put(Context.SECURITY_CREDENTIALS, password);
    }
    return new InitialContext(p);
    }
    }and here is the exception I get:
    javax.ejb.CreateException: Create failed because primary key is null

    I don't understand why I get this as the primary key is "toto" and therefore is not null.

    Here is the DD:

    ?xml version="1.0" encoding="UTF-8"?

    !DOCTYPE ejb-jar PUBLIC "-//Sun Microsystems, Inc.//DTD Enterprise JavaBeans 2.0//EN" "http://java.sun.com/dtd/ejb-jar_2_0.dtd"

    ejb-jar
    display-nameAccount EJB/display-name
    enterprise-beans
    entity
    display-nameAccount EJB/display-name
    ejb-nameAccountEJB/ejb-name
    homecom.parispano.account.entity.AccountHome/home
    remotecom.parispano.account.entity.Account/remote
    local-homecom.parispano.account.entity.AccountLocalHome/local-home
    localcom.parispano.account.entity.AccountLocal/local
    ejb-classcom.parispano.account.entity.AccountEJB/ejb-class
    persistence-typeContainer/persistence-type
    prim-key-classjava.lang.String/prim-key-class
    reentrantFalse/reentrant
    cmp-version2.x/cmp-version
    abstract-schema-nameaccount/abstract-schema-name
    cmp-field
    descriptionLogin/description
    field-namelogin/field-name
    /cmp-field
    !-- --
    cmp-field
    descriptionPassword/description
    field-namepassword/field-name
    /cmp-field
    cmp-field
    descriptionSurname/description
    field-namesurname/field-name
    /cmp-field
    cmp-field
    descriptionFirst Name/description
    field-namefirstName/field-name
    /cmp-field
    cmp-field
    descriptionAddress One/description
    field-nameaddressOne/field-name
    /cmp-field
    cmp-field
    descriptionAddress Two/description
    field-nameaddressTwo/field-name
    /cmp-field
    cmp-field
    descriptionPostcode/description
    field-namepostcode/field-name
    /cmp-field
    cmp-field
    descriptionCity/description
    field-namecity/field-name
    /cmp-field
    cmp-field
    descriptionCountry/description
    field-namecountry/field-name
    /cmp-field
    cmp-field
    descriptionTelephone/description
    field-nametelephone/field-name
    /cmp-field
    cmp-field
    descriptionEmail/description
    field-nameemail/field-name
    /cmp-field
    cmp-field
    descriptionInscription Date/description
    field-nameinscriptionDate/field-name
    /cmp-field
    cmp-field
    descriptionLast Visit Date/description
    field-namelastVisitDate/field-name
    /cmp-field
    primkey-fieldlogin/primkey-field
    /entity
    /enterprise-beans
    /ejb-jarCan anyone tell me why I am getting this exception please?

    Thanks in advance,

    Julien Martin.

    DB:3.25:Sos: Javax.Ejb.Createexception: Create Failed Because Primary Key Is Null ck

    Yes, I have set the PK. Actually this is happening when the number of columns are more than 63 columns. After I reduce the number of column, it is working fine.
    Is it the actual problem???

    fyi, I'm using jboss as the Application Server...

  • RELEVANCY SCORE 3.24

    DB:3.24:How To Calculate A Date Field 1x


    Hello everyone! I am creating a form for our clients and i am trying to create an auto fill in field based on the information the client enters in another field but not sure how. Senario:Client enters date (ie 01/12/2012) in field 4 and then in Field 6 the calcuation is done and result entered (clients date plus 45 days). Field 4 I selected date mm/dd/yyyy. Not sure what to do in properties in field 6 to get end result.Any help would be great!

    DB:3.24:How To Calculate A Date Field 1x

    Hello everyone! I am creating a form for our clients and i am trying to create an auto fill in field based on the information the client enters in another field but not sure how. Senario:Client enters date (ie 01/12/2012) in field 4 and then in Field 6 the calcuation is done and result entered (clients date plus 45 days). Field 4 I selected date mm/dd/yyyy. Not sure what to do in properties in field 6 to get end result.Any help would be great!

  • RELEVANCY SCORE 3.24

    DB:3.24:Syclo - Clearing/Unsetting Date Fields dx



    Hi All,

    I'm having some trouble with clearing a date field. I need to have the option of setting a date field back to blank if the user request so.

    I've tried to create a transaction where the date is a string property and set the date as blank. When running the application, clearing the date field results in the error message Date field is required and I'm not able to clear the field.

    Thanks in advance for any hints on how to clear a date field.

    Thanks!

    Tags edited by: Michael Appleby

  • RELEVANCY SCORE 3.23

    DB:3.23:Timeline Date In Planning Board z8



    Hi All,

    There is a field in Planning Board called Timeline Date ( Menu, Settings Options Settings (Tab) Timeline Date field ) which draws a vertical line across all the activities in Planning Board. Apart from that it has got any other purpose ? Timeline Date of SAP is look like Data Date in Primavera, but in Primavera Data Date will push (shift) the activities which are late to start. Kindly put some light on Timeline Date field of SAP.

    Thanks

    DB:3.23:Timeline Date In Planning Board z8


    Hi All,

    There is a field in Planning Board called Timeline Date ( Menu, Settings Options Settings (Tab) Timeline Date field ) which draws a vertical line across all the activities in Planning Board. Apart from that it has got any other purpose ? Timeline Date of SAP is look like Data Date in Primavera, but in Primavera Data Date will push (shift) the activities which are late to start. Kindly put some light on Timeline Date field of SAP.

    Thanks

  • RELEVANCY SCORE 3.22

    DB:3.22:Time Input Field xx



    How to i create a time input field similar to a date input field with a calenda

    DB:3.22:Time Input Field xx


    Hi,

    We currently do not support a time input field.

    Regards,

    Brian

  • RELEVANCY SCORE 3.22

    DB:3.22:Dynamic Action On A Field jd



    Hi,

    I need to create dynamic action for a field(Date) in IT077 and in IT019 it should update the valid date field.

    I created dynamic action but the date in IT077 is not coming up automatically in IT019 for a subtype which is assigned in IT019.

    Any help will be greatly appreciated.

    Regards,

    Sumana

    DB:3.22:Dynamic Action On A Field jd


    Please use Rajashekar reddy's code. Time types used in his code work best with dynamic actions. I have used them in many cases

  • RELEVANCY SCORE 3.21

    DB:3.21:Flag Custom Field To Check Date Custom Field 7s


    Hi there!
    I need to create a flag custom field to check if the date in a date custom field is before or after today. I check it all right if the date field has a value. But how can I check if I don't select a date and the value has 'NOD'? I can't find the way... :(
    Regards.
    LyE

    DB:3.21:Flag Custom Field To Check Date Custom Field 7s

    Thanks Barbara!
    You assume fine... :) Now I compare with the 4294967295 and works fine!
    Regards.
    LyE

  • RELEVANCY SCORE 3.20

    DB:3.20:How To Create A New Date/Time Field To Reference Resolution Date/Time? k8



    I am working in SFA and I need to create a new Date/Time field to show the date and time the lead's state changed to (a status I created in SFA called) Resolved. I have created the date/time field, but I don't know whow to make it populate when the state is changed to resolved. Please help!

  • RELEVANCY SCORE 3.20

    DB:3.20:Incorrect Date Format jz



    Hi People!

    I'm having this issue where I'm storing the keyword $DATE$ from a Date-Only field. I created a test filter to basically just push the TIMESTAMP and DATE keywords to their corresponding field

    Here's the filter Push Field action:

    Date/Time Field = $TIMESTAMP$

    Date Field = $DATE$

    I've tried enabling the filter log and here's the result:

    Date/Time Field (536870913) = 03/11/2011 15:34:44

    Date Field (536870915) = 11/03/11

    Notice that the Date/Time Field has the AU format (correct one - dd/mm/yyyy HH:mm:ss), while the Date Field has the US (incorrect- mm/dd/yy)

    Now my question is, where do I need to start looking to get the Date Time field in the format I want (which is in AU - dd/mm/yyyy)?

    I'm using AR Server 7.0.1 on Oracle10g db.

    Thanks,

    Gabud

    DB:3.20:Incorrect Date Format jz


    Thanks Misi!

    You've been very helpful. The issue has now been addressed by the vendor. They have reproduced it from the log file. They have escalated this to BMC Support and it was tagged as an RFE.

    Thanks again!

  • RELEVANCY SCORE 3.19

    DB:3.19:Date Field j9


    I created a date field with the calendar and help icon. When I create a pdf, they are not there. Also, can I get rid of the field label.

    DB:3.19:Date Field j9

    Hi, I see, hope this clarifies your questions: I created a date field with the calendar and help icon. When I create a pdf, they are not thereThis is the correct behavior. Right now we don't show the date calendar or the help icon in the pdf. If you like you can add this as a feature request: http://forums.adobe.com/community/formscentral?view=idea Also, can I get rid of the field label. You can get rid of it in the pdf form by editing the pdf form in Acrobat and delete the text associated with the field label. You cannot get rid of it via FormsCentral. You can leave it blank and it will show up as blank in the pdf or html form. Thanks, Lucia

  • RELEVANCY SCORE 3.19

    DB:3.19:Implementing My Own Date Field dp



    Due to some compatibility issues I cannot use the blackberry defalut date field. so now i need to create my won date field. I would really appreciate if someone could give some suggesion or links to a similar implementation. I need to do this for 4.2.1...







    Solved!
    Go to Solution.

    DB:3.19:Implementing My Own Date Field dp


    Marking this as solved started another thread with more details...

  • RELEVANCY SCORE 3.19

    DB:3.19:Send Email After A Create In A Form cs


    I guys, i create a form for an intern application. I have a problem. I want to send an email after a push the create button. I create a process the type send email. So, when i push the button create, i receive correcly the email. But, i want to receive the info that i was just create. Example: i have a text field name, a radio button and a field Date.

    I want to receive in my email the information of my text field, of my radio button and my field Date. I think i can do something with the sql statement but i have an error when i try to send with a simple select of my columns.
    This is the error : Error ORA-20001: Email has a wrong data type in SQL statement. Column# 1 is VARCHAR2 but BLOB expected.

    Anybody have an idea about to use de process type Send Email

    Thanks

    Guillaume

    P.s. Sorry for my english, i'm a frenchie guy

  • RELEVANCY SCORE 3.19

    DB:3.19:Set Field And Push Field ca



    HI,

    I am new to Remedy .

    So, Can you tell me what is set field and push field .

    what is the function of this setfield and push field with example.

    DB:3.19:Set Field And Push Field ca


    Hi

    Set Field and Push Field:-

    It is used in Active Link as well as in Filter. I have mentioned the basic difference between Active Link's set field,push field and Filter's set field, push field.

    Set Field for Active Link:-

    If you select "current screen" option in set field it will set the value for that field temporarily on the same(current) form. It is just for that transaction only.

    If you select "Server"option in set field you can set the field to another server's any form or the same server's any form. that is Dynamic data destination is available.

    Set Field for Filter :-

    If you select "current transaction" option in set field it will set the value for that field permanentaly on the same(current) form. It stores the data to database.

    If you select "Server" option you can set the values on the same server. you cannot select the another server in filters. that is Dynamic data destination is not available.

    Push Field for Active Link :-

    If you select the "server" option in push field it will push the data to the selected form on selected server.

    It will store the data to database. Here also you can select another server. that is Dynamic data destination is available.

    Push Field for Filter :-

    If you select "server" option in push field it will push the data to the selected form on the same server.

    It will store the data to database. Here you can not select another server. that is Dynamic data destination is not available.

    Regards,

    Snehal

  • RELEVANCY SCORE 3.19

    DB:3.19:Filter With Dates 7x



    Is it possible to compare a Date field with a Date/Time field? Right now I get:

    Data types are not appropriate for relational operation (ARERR 313).

    Any work arounds? I would rather not create a new hidden date/time field and populate it with the value of the date field in an escallation, then use a filter to keep it in sync.

  • RELEVANCY SCORE 3.19

    DB:3.19:How To Create Dotted Line Under A Region In Page 1x


    I have to create a region like this

    Registration

    Initial regitration
    Date Prepared field Date received
    ------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    LTO registration
    Registration No Date

    DB:3.19:How To Create Dotted Line Under A Region In Page 1x

    Manish,

    Create a message Layout Region Under MessageComponent Layout

    Then under Message Layout Region - Seperator.

    Regards,
    Gyan

  • RELEVANCY SCORE 3.19

    DB:3.19:Parameter Date Field With Only Mm-Yyyy Mask xx


    hii want to create a parameter field with only mount/year.it's possible ?i'm in Crystal 2008

    DB:3.19:Parameter Date Field With Only Mm-Yyyy Mask xx

    what i have done :create a table dimension time with year_mounth_stringcreate a procedure who populates the table from 2008 until 2023in crystal a LOV from that table thanks for all your answer

  • RELEVANCY SCORE 3.19

    DB:3.19:What Is The Difference Between Set Field And Push Field? dz



    What is the difference between set field and push field?

    DB:3.19:What Is The Difference Between Set Field And Push Field? dz


    Forgot to mentition .. you can use set field for working with arithmatic expressions like sum count etc

    Thanks

  • RELEVANCY SCORE 3.19

    DB:3.19:Cannot Create A Incident From Ao s3



    Hi,

    I'm attempting to create a ticket from AO into Remedy 7.5.00.

    I have altered the AutoPilot-OA-Incident_Management:Setup_Validation:Test Create Incidents process to add a few more fields that are required to create the Incident.

    These have been added using the incident context item, but when I run the test I see the following in the debug logs, where certain field names are not being populated in the XML.

    values

    field name="z1D_Action"![CDATA[CREATE]]/field

    field name=""![CDATA[GL-RemedyITSM-Support]]/field

    field name=""![CDATA[SGP000000000489]]/field

    field name=""![CDATA[Nomura]]/field

    field name=""![CDATA[Global]]/field

    field name=""![CDATA[Failure]]/field

    field name=""![CDATA[Availability]]/field

    field name=""![CDATA[Down]]/field

    field name=""![CDATA[Nomura International PLC]]/field

    field name=""![CDATA[Nomura International PLC]]/field

    field name=""![CDATA[Nomura International PLC]]/field

    field name="First_Name"![CDATA[Paul]]/field

    field name="Impact"![CDATA[4000]]/field

    field name="Last_Name"![CDATA[Ryder]]/field

    field name="Detailed_Decription"![CDATA[Test Testing]]/field

    field name=""![CDATA[pryder]]/field

    field name=""![CDATA[3]]/field

    field name="Reported Source"![CDATA[3000]]/field

    field name="Service_Type"![CDATA[1]]/field

    field name="Description"![CDATA[This is a test incident creation message.]]/field

    field name="Status"![CDATA[0]]/field

    field name=""![CDATA[pryder]]/field

    field name="Urgency"![CDATA[4000]]/field

    /values]

    This is only for the fields that I have added.

    Is there anything I have obviously missed?

    Many Thanks,

    Paul.

    DB:3.19:Cannot Create A Incident From Ao s3


    Thanks, that makes a lot more sense now and I've tried it for the Cat1/2/3 and it seems to work.

    I have not added anything to the Concept, just to the field incident -- Incidents mapping, but just used what was there so it's strange that BMC do not supply complete mappings for all their Concept items.

    Many Thanks and a Very Merry Christmas

    Paul.

  • RELEVANCY SCORE 3.18

    DB:3.18:Sales Order "Required Delivery Date" Mandatory Field xs



    Hi all,

    We want to create sales orders with blank required delivery date field. We will fill this field in future time cause of our processes. But it is a mandatory field when creating order.

    Can we implement this as above not a mandatory field and will it have negative effects to the system ?

    Thanks,

  • RELEVANCY SCORE 3.18

    DB:3.18:How To Have A Calendar? x3



    Hi,

    I have a field name: Requested Date, I want this field name to be the basis of my calendar.

    Table:

    Fields:

    Requested No,

    Requested Date

    Would it be possible to create a calendar from which minimum date and maximum date is extracted from Requested Date?

    Need help from you guys, thanks.

    Best Regards,

    Bill

  • RELEVANCY SCORE 3.17

    DB:3.17:Getting Date Format Invalid Error 9z



    Hello,

    I ve created a regular form in which i added one extra Date/Time field. I need to push the value in the create date field to this new field date/time field.

    in the new date/time field i should get create date value+ 86400 i.e suppose i create the ticket and its create date is 19/08/2010 4:00:00 PM then in the new date/time field i should see 20/08/2010 4:00:00 PM ..

    I created the filter for this but i see the below error being displayed

    Filed assignment Error(8957): The date format is invalid..

    Please help how can i resolve this..

    Thx...

  • RELEVANCY SCORE 3.17

    DB:3.17:Abap: Input Field With Calendar Help kc



    Hello,

    How can I create an input field with a help button which brings up a calendar to select a date?

    Thank you.

    DB:3.17:Abap: Input Field With Calendar Help kc


    Hi Maksim,

    10 points just came your way.

    Thanks!

  • RELEVANCY SCORE 3.17

    DB:3.17:Date Format Addtional Field sx



    hai daer

    DB:3.17:Date Format Addtional Field sx


    Another way is

    sum({SHKZG ={'S'}, BUDAT={"$(=Date(VstartDate,'DD-MM-YYYY'))"}}MENGE) - sum({SHKZG ={'H'}

    , BUDAT={"$(=Date(VstartDate,'DD-MM-YYYY'))"}

    }MENGE)

  • RELEVANCY SCORE 3.17

    DB:3.17:Date Comparison fk



    Dear All,

    I create done the bdc recording in that recording i have a one date field i have validate that field ,field date can not be less then 01.04.2009 if that is then i have to thrw the message in that

    I am not able to do that comparison kindly help me to resolve this issue.

    thanks

    DB:3.17:Date Comparison fk


    Moderator message - Please see How to post code in SCN, and some things NOT to do... before posting - post locked

  • RELEVANCY SCORE 3.16

    DB:3.16:Create Date Field From Yearmonth Field c9



    hello.

    is there anyway to create date field from YearMonth Field?

    YearMonth

    201301

    Date

    20130101

    20130102

    20130103....................................

    Best

    Brad

    DB:3.16:Create Date Field From Yearmonth Field c9


    Hi,

    You are getting date field converted in num field.

    So you can get it that field into list box-Property-Number-select Dateformat-give format which you want.

    Or simply give date(dateFieldName,'YYYYMM')

    Regards

  • RELEVANCY SCORE 3.16

    DB:3.16:Custom Field In T0015 3a


    Hi Experts,I have to create a custom field in IT0015 in which in can enter some date just for the information purpose.Plz tell me how i can do this.regardsTS

    DB:3.16:Custom Field In T0015 3a

    Refer these threads - Infotype Enhancement very urgentHR Infotype enhancement

  • RELEVANCY SCORE 3.16

    DB:3.16:Create Alert From A Date Field 7m


    Create Alert from a Date Field

    Hello, I would like to know how I create
    automatically, from a date
    field (after entering the date
    in it), an alert appears
    warning within 15 days maturity of
    term. I hope understand my question.
    Thank you!

  • RELEVANCY SCORE 3.16

    DB:3.16:How To Send The Data From One Server To Other Server Using Push Field? ca


    How to send the Data from one server to other server using Push field?

    I have used push field and mentioned other server in push field but it is showing me the error ARERR(90)

    Can you please let me know?

    DB:3.16:How To Send The Data From One Server To Other Server Using Push Field? ca


    Hi,

    ARERR 90 is not a password problem, it is a connectivity problem.

    Presumably the portmapper is turned off, and the client is not configured to connect directly to the second servers configured tcp-port.

    The login+password, as mentioned, needs to be correct. But that is the next step.

    Best Regards - Misi, RRR AB, http://rrr.se

  • RELEVANCY SCORE 3.16

    DB:3.16:Date-Field Shows As Integer Number xd



    Dear all,

    I want to use a date-field in an SRD that I push into the Notes-field of a change ticket.

    But in a multilingual environments (8 locales) the date is shown as an integer number format instead of as a date format.

    Any idea how to resolve?

    Best regards,

    Gil

    DB:3.16:Date-Field Shows As Integer Number xd


    Gil Peeters

    While u r mapping to the notes fields for Date field we have to User Display Response and Internal for date we have to select Internal response when u r mapping to Notes field

    Thanks

    Sanjeeva Naidu Gurram

  • RELEVANCY SCORE 3.16

    DB:3.16:How Do I Get Month, Date, Year, Time, Etc. From Timestamp Field cf



    I imported a date and time field from Microsoft Access and put data in FM timestamp field. Data in timestamp field is in the following format: 4/22/2006 6:32:50 PM.

    I'm trying to create year, month, day of week, and time fields from the data in the timestamp field but the date functions [i.e. month(date), year(date), etc.] do not work. I am hoping that there is a simple solution... in MS Access, their functions work for the time/date field format above. Any help will be much appreciated.

    DB:3.16:How Do I Get Month, Date, Year, Time, Etc. From Timestamp Field cf


    Thanks everyone for all your help. Skywillmott's example was particularly useful for a beginner (or dummy) like me.

  • RELEVANCY SCORE 3.16

    DB:3.16:Date Issues While Creating A Variant. a8



    HI,

    I have a report with a date field, which is hard coded where from date = 1st day of month and todate = system date -1,

    How do i create a variant with the date field set as above.

    I need to create a variant, so that i can schedule the report daily.

    Rgds

    Norman

    DB:3.16:Date Issues While Creating A Variant. a8


    While saving the variant.....

    1. Select selection variable as D for TO date

    2. Select Current date - XXX days as give it as -1 so it will show as currentday- 1 days....

    1. Select selection variable as D for FROM date

    2. Select First day of current month.....

    You can set these values in ALV options bar displayed in variant maintenance....

    Don't go for TVARVC or manually changing the variant through code...it's the easiest option available...

  • RELEVANCY SCORE 3.15

    DB:3.15:How Do I Insert A Drop Down Calender To Insert The Date Field. 33



    How do i insert a drop down calender to insert the date field i my create a form

    DB:3.15:How Do I Insert A Drop Down Calender To Insert The Date Field. 33


    Hi,

    You can use the date object FormsCentral provides. When you test the form in browser, the date field will show a pulldown calendar when clicked upon.

    Thanks,

    Wenlan

  • RELEVANCY SCORE 3.15

    DB:3.15:Does The Datasource Must Have A Timestamp Field? zp



    When I want to realize the Delta update in SAP BI,does the datasource must have a timestamp field?

    1. If I create the datasource in ECC,do I must create the timestamp field manually?

    2. May there are some date type fields in a datasource,so if I must create the timestamp field in the datasource,how can the SAP BI extractor recognize which date type field is?Is there any definition rule such as name about the timestamp field created manually?

    DB:3.15:Does The Datasource Must Have A Timestamp Field? zp


    Thanx for mansi dandavate's replay.

    In Generic:

    Settings

    Safety Interval Upper Limit

    Safety Interval Lower Limit

    Real-Time Enabled

    New Status for Changed Records

    Additive Delta

    I've read the SAP help,but the description is still too technical,so could you tell me by an instance that when and how to set them?

  • RELEVANCY SCORE 3.15

    DB:3.15:Date Type Number Format Fixed Field Entry Still Getting Rounded To Integer m9


    With Access 2007, I create a new database, create a new table and new field. I select the field and set the Date Type = Number and theFormat = Fixed. When I type a number into this field, it is rounded to an Integer. This is true regardless of the
    number of digits I select to display.
    E.g. I type 2.11 into the field, and when I tab to the next field, the value is rounded to 2.00.
    Thank you.

    DB:3.15:Date Type Number Format Fixed Field Entry Still Getting Rounded To Integer m9

    You need to change the FIELD SIZE from Long Integer which is the default to a type which can handle decimals (single, double, decimal).

    Bob Larson, Former Access MVP (2008-2010) http://www.btabdevelopment.com (free Access tools, tutorials, and samples)

  • RELEVANCY SCORE 3.14

    DB:3.14:Create A Week Commencing Field In Script fk



    Hi All,

    How do i create a field in my master calendar for week commencing?

    I am looking for the week commencing date for every week.

    Thanks

    DB:3.14:Create A Week Commencing Field In Script fk


    You can write like

    WeekStart(Week(DateField)) as WeekStart

  • RELEVANCY SCORE 3.14

    DB:3.14:Copying System.Reason Always Gets Old Value aj


    I am working with a 3rd party tool to manage requirements, and it has a TFS sync process. I am creating bugs, tasks, and change requests in this tool, and pushing them to TFS. I can update in TFS and pull back into this tool.
    You have to create a custom work item type to perform this push/pull, so I have done this and tried to mimic the existing TFS Task, Bug, and Change Request wit from the CMMI Process Template. The 3rd party syncs up with the TFS State field, but I had
    to create a custom Reason field in my 3rd party tool. I am trying to copy the value from System.Reason to my new field, but when I perform the copy, I always get the previous value of System.Reason. I have tried countless combinations of attempts
    at copying, to no avail. There is no problem with the sync process, because I can test this behavior strictly in TFS and see the results in the History tab.
    Following is the applicable section of the wit. Thanks in advance for the help!

    FIELD name=Tracking Item Reason refname=TechnoSolutions.TrackingItem.TrackingItemReason type=String

    WHENCHANGED field=System.State

    COPY from=field field=System.Reason/

    /WHENCHANGED

    /FIELD

    /FIELDS

    WORKFLOW

    STATES

    STATE value=Proposed

    FIELDS

    FIELD refname=Microsoft.VSTS.Common.ResolvedDate

    EMPTY /

    /FIELD

    FIELD refname=Microsoft.VSTS.Common.ResolvedBy

    EMPTY /

    /FIELD

    FIELD refname=Microsoft.VSTS.Common.ClosedDate

    EMPTY /

    /FIELD

    FIELD refname=Microsoft.VSTS.Common.ActivatedDate

    EMPTY /

    /FIELD

    FIELD refname=Microsoft.VSTS.Common.ClosedBy

    ALLOWEXISTINGVALUE /

    EMPTY /

    /FIELD

    FIELD refname=Microsoft.VSTS.Common.ActivatedBy

    ALLOWEXISTINGVALUE /

    EMPTY /

    /FIELD

    /FIELDS

    /STATE

    STATE value=Active

    FIELDS

    FIELD refname=Microsoft.VSTS.Common.ResolvedDate

    EMPTY /

    /FIELD

    FIELD refname=Microsoft.VSTS.Common.ResolvedBy

    EMPTY /

    /FIELD

    FIELD refname=Microsoft.VSTS.Common.ClosedDate

    EMPTY /

    /FIELD

    FIELD refname=Microsoft.VSTS.Common.ActivatedDate

    REQUIRED /

    /FIELD

    FIELD refname=Microsoft.VSTS.Common.ClosedBy

    ALLOWEXISTINGVALUE /

    EMPTY /

    /FIELD

    FIELD refname=Microsoft.VSTS.Common.ActivatedBy

    ALLOWEXISTINGVALUE /

    REQUIRED /

    /FIELD

    FIELD refname=System.AssignedTo

    ALLOWEXISTINGVALUE /

    REQUIRED /

    /FIELD

    /FIELDS

    /STATE

    STATE value=Resolved

    FIELDS

    FIELD refname=Microsoft.VSTS.Common.ClosedDate

    EMPTY /

    /FIELD

    FIELD refname=Microsoft.VSTS.Common.ResolvedDate

    REQUIRED /

    /FIELD

    FIELD refname=Microsoft.VSTS.Common.ResolvedBy

    REQUIRED /

    /FIELD

    FIELD refname=Microsoft.VSTS.Common.ClosedBy

    ALLOWEXISTINGVALUE /

    EMPTY /

    /FIELD

    FIELD refname=System.AssignedTo

    ALLOWEXISTINGVALUE /

    REQUIRED /

    /FIELD

    /FIELDS

    /STATE

    STATE value=Closed

    FIELDS

    FIELD refname=Microsoft.VSTS.Common.ClosedDate

    REQUIRED /

    /FIELD

    FIELD refname=Microsoft.VSTS.Common.ClosedBy

    ALLOWEXISTINGVALUE /

    REQUIRED /

    /FIELD

    FIELD refname=System.AssignedTo

    ALLOWEXISTINGVALUE /

    EMPTY /

    /FIELD

    /FIELDS

    /STATE

    /STATES

    TRANSITIONS

    TRANSITION from= to=Proposed

    REASONS

    DEFAULTREASON value=New /

    /REASONS

    FIELDS

    FIELD refname=System.AssignedTo

    DEFAULT from=currentuser /

    /FIELD

    /FIELDS

    /TRANSITION

    TRANSITION from=Proposed to=Active

    REASONS

    DEFAULTREASON value=Investigate /

    REASON value=Accepted /

    /REASONS

    FIELDS

    FIELD refname=Microsoft.VSTS.Common.ActivatedDate

    SERVERDEFAULT from=clock /

    /FIELD

    FIELD refname=Microsoft.VSTS.Common.ActivatedBy

    COPY from=currentuser /

    /FIELD

    /FIELDS

    /TRANSITION

    TRANSITION from=Active to=Proposed

    REASONS

    DEFAULTREASON value=Investigation Complete /

    /REASONS

    /TRANSITION

    TRANSITION from=Active to=Closed

    REASONS

    DEFAULTREASON value=Complete and Does Not Require Review/Test /

    REASON value=Deferred /

    REASON value=Cut /

    REASON value=Overtaken by events /

    REASON value=Cancelled /

    /REASONS

    FIELDS

    FIELD refname=Microsoft.VSTS.Common.ClosedDate

    SERVERDEFAULT from=clock /

    /FIELD

    FIELD refname=Microsoft.VSTS.Common.ClosedBy

    COPY from=currentuser /

    /FIELD

    /FIELDS

    /TRANSITION

    TRANSITION from=Active to=Resolved

    REASONS

    DEFAULTREASON value=Complete /

    REASON value=Requires Review/Test /

    /REASONS

    FIELDS

    FIELD refname=Microsoft.VSTS.Common.ResolvedDate

    SERVERDEFAULT from=clock /

    /FIELD

    FIELD refname=Microsoft.VSTS.Common.ResolvedBy

    COPY from=currentuser /

    /FIELD

    /FIELDS

    ACTIONS

    ACTION value=Microsoft.VSTS.Actions.Checkin /

    /ACTIONS

    /TRANSITION

    TRANSITION from=Closed to=Active

    REASONS

    DEFAULTREASON value=Reactivated /

    REASON value=Closed in Error /

    /REASONS

    FIELDS

    FIELD refname=Microsoft.VSTS.Common.ActivatedDate

    SERVERDEFAULT from=clock /

    /FIELD

    FIELD refname=Microsoft.VSTS.Common.ActivatedBy

    COPY from=currentuser /

    /FIELD

    FIELD refname=System.AssignedTo

    COPY from=field field=Microsoft.VSTS.Common.ClosedBy /

    /FIELD

    /FIELDS

    /TRANSITION

    TRANSITION from=Resolved to=Active

    REASONS

    DEFAULTREASON value=Review/Test Failed /

    /REASONS

    FIELDS

    FIELD refname=Microsoft.VSTS.Common.ActivatedDate

    SERVERDEFAULT from=clock /

    /FIELD

    FIELD refname=Microsoft.VSTS.Common.ActivatedBy

    COPY from=currentuser /

    /FIELD

    /FIELDS

    /TRANSITION

    TRANSITION from=Resolved to=Closed

    REASONS

    DEFAULTREASON value=Review/Test Passed /

    /REASONS

    FIELDS

    FIELD refname=Microsoft.VSTS.Common.ClosedDate

    SERVERDEFAULT from=clock /

    /FIELD

    FIELD refname=Microsoft.VSTS.Common.ClosedBy

    COPY from=currentuser /

    /FIELD

    /FIELDS

    /TRANSITION

    /TRANSIT

    DB:3.14:Copying System.Reason Always Gets Old Value aj

    Hi subucni,
    Is your issue solved? I am marking the reply as answer, if you have any concern, please feel free to unmark it.
    Best Regards,Cathy Kong [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

  • RELEVANCY SCORE 3.13

    DB:3.13:Blank Fields Are Shown, Ssrs Report Based On Date Field, Ms Crm 2013 Online 1j


    Hi,

    I have a requirement to create 3 reports based on opportunity expected close date field.

    DB:3.13:Blank Fields Are Shown, Ssrs Report Based On Date Field, Ms Crm 2013 Online 1j

    Hi,
    Its working.only thing was i used=DateAdd(DateInterval.Day,30,Today) this expression.
    Ur Approach is useful. Thank u so much...

  • RELEVANCY SCORE 3.13

    DB:3.13:What Is Difference Between Push Field And Directsql? pk



    can i help me

    DB:3.13:What Is Difference Between Push Field And Directsql? pk


    Both are used to insert or to update records in the tables...but push field is an action which will be initiated by the application and triggers the event of submit or update in the form which is in context and application objects like filter would be invoked executes the logic if any filters written on the submit or modify...or on that particular event then the data in that form will be sent to the database that query internally will be formed by the at system and the record finally gets saved in the database....

    Now if you want to insert or update a row in a table by passing the application layer then you can write direct SQL which jus passes the SQL statement to the database ....so it would be like you going to database client and inserting or updating the records through SQL statement...so no application logic fires for you ...

    But case of push field it's like through the application or ar system ...insert event gets triggered execute the filters if any then internally form the SQL statement by the at itself and passes to db...this is the key difference of these 2.

  • RELEVANCY SCORE 3.13

    DB:3.13:Cmr Canot Be Set To Null !! 1f


    Hi !
    In our application we have two entity beans lets say A and B.
    There is a one to many relationships between them: A 1..n B
    Navigability is only from B to A
    When I set the CMR field from B to null nothing is happened (no update in
    database)
    When I set the CMR field to an existing entity bean A the database is updated
    correctly.
    The problem is how I can set the CMR field from B to null

    There are no constraints in database !

    test method from session facade:

    public void createAngajat(){
    try {
    javax.naming.Context ctx = new javax.naming.InitialContext();
    InvestigatieLocalHome homeInv = (InvestigatieLocalHome)ctx.lookup ("java:comp/env/ejb/InvestigatieLocal");
    InvestigatieLocal scl=homeInv.findByPrimaryKey(new Long(24));
    System.err.println("T0 Medic value="+scl.getMedic());
    System.err.println("Set NULL");
    scl.setMedic(null);
    System.err.println("T1 Medic value='"+scl.getMedic()+"' not NULL");
    } catch (javax.naming.NamingException e) {
    e.printStackTrace();
    } catch (FinderException e) {
    e.printStackTrace();
    }
    }

    Database script:

    create table ANGAJAT
    (
    IDANGAJAT NUMBER NOT NULL ,
    IDCATMED NUMBER ,
    IDSPECIALITATE NUMBER ,
    IDSECTIE NUMBER ,
    NUME VARCHAR2(50) ,
    CNP VARCHAR2(20) ,
    ALTEINFORMATII VARCHAR2(3000) )
    /

    create table INVESTIGATIE
    (
    IDINV NUMBER NOT NULL ,
    IDFO NUMBER ,
    IDANGAJAT NUMBER ,
    CODDRG VARCHAR2(20) ,
    TEXTDRG VARCHAR2(255) ,
    DATA DATE ,
    ORA NUMBER ,
    APROBATADE VARCHAR2(100) ,
    GRADURGENTA NUMBER ,
    OBSERVATII VARCHAR2(4000) ,
    REZULTAT VARCHAR2(4000) ,
    RADIOLOGICA NUMBER )
    /

    this is ejb-jar.xml

    ejb-jar
    enterprise-beans
    session
    ejb-nameAngajatController/ejb-name
    homecom.asf.hmis.server.pacient.AngajatControllerHome/home
    remotecom.asf.hmis.server.pacient.AngajatController/remote
    ejb-classcom.asf.hmis.server.pacient.AngajatControllerBean/ejb-class
    session-typeStateless/session-type
    transaction-typeContainer/transaction-type
    ejb-local-ref
    ejb-ref-nameejb/InvestigatieLocal/ejb-ref-name
    ejb-ref-typeEntity/ejb-ref-type
    local-homecom.asf.hmis.components.pacient.InvestigatieLocalHome/local-home
    localcom.asf.hmis.components.pacient.InvestigatieLocal/local
    ejb-linkInvestigatie/ejb-link
    /ejb-local-ref
    /session
    entity
    descriptionEntity Bean ( CMP )/description
    display-nameInvestigatie/display-name
    ejb-nameInvestigatie/ejb-name
    local-homecom.asf.hmis.components.pacient.InvestigatieLocalHome/local-home
    localcom.asf.hmis.components.pacient.InvestigatieLocal/local
    ejb-classcom.asf.hmis.components.pacient.InvestigatieBean/ejb-class
    persistence-typeContainer/persistence-type
    prim-key-classjava.lang.Long/prim-key-class
    reentrantFalse/reentrant
    cmp-version2.x/cmp-version
    abstract-schema-nameInvestigatie/abstract-schema-name
    cmp-field
    field-nameidInvestigatie/field-name
    /cmp-field
    cmp-field
    field-namecodDrg/field-name
    /cmp-field
    cmp-field
    field-nametextDrg/field-name
    /cmp-field
    cmp-field
    field-namedata/field-name
    /cmp-field
    cmp-field
    field-nameora/field-name
    /cmp-field
    cmp-field
    field-nameaprobataDe/field-name
    /cmp-field
    cmp-field
    field-namegradUrgenta/field-name
    /cmp-field
    cmp-field
    field-nameobservatii/field-name
    /cmp-field
    cmp-field
    field-namerezultat/field-name
    /cmp-field
    cmp-field
    field-nameradiologica/field-name
    /cmp-field
    cmp-field
    field-nameidFo/field-name
    /cmp-field
    primkey-fieldidInvestigatie/primkey-field
    /entity
    entity
    descriptionEntity Bean ( CMP )/description
    display-nameAngajat/display-name
    ejb-nameAngajat/ejb-name
    local-homecom.asf.hmis.components.pacient.AngajatLocalHome/local-home
    localcom.asf.hmis.components.pacient.AngajatLocal/local
    ejb-classcom.asf.hmis.components.pacient.AngajatBean/ejb-class
    persistence-typeContainer/persistence-type
    prim-key-classjava.lang.Long/prim-key-class
    reentrantFalse/reentrant
    cmp-version2.x/cmp-version
    abstract-schema-nameAngajat/abstract-schema-name
    cmp-field
    field-nameidAngajat/field-name
    /cmp-field
    cmp-field
    field-nameidSpecialitate/field-name
    /cmp-field
    cmp-field
    field-namenume/field-name
    /cmp-field
    cmp-field
    field-namecnp/field-name
    /cmp-field
    cmp-field
    field-namealteInformatii/field-name
    /cmp-field
    cmp-field
    field-nameidCatMed/field-name
    /cmp-field
    primkey-fieldidAngajat/primkey-field
    /entity
    /enterprise-beans
    relationships
    ejb-relation
    ejb-relation-nameInvestigatie:Angajat/ejb-relation-name
    ejb-relationship-role
    multiplicityMany/multiplicity
    relationship-role-source
    ejb-nameInvestigatie/ejb-name
    /relationship-role-source
    cmr-field
    cmr-field-namemedic/cmr-field-name
    /cmr-field
    /ejb-relationship-role
    ejb-relationship-role
    multiplicityOne/multiplicity
    relationship-role-source
    ejb-nameAngajat/ejb-name
    /relationship-role-source
    /ejb-relationship-role
    /ejb-relation
    /relationships
    /ejb-jar

    DB:3.13:Cmr Canot Be Set To Null !! 1f


    The problem is the generated PersistenceManager class
    When set the cmr field to null the manager remove the reference from other side collection mark the field dirty but not set the field to null and the old value remain set

    ________________________________________
    Craciun Bogdan Catalin
    Software Engineer - Advantage Software Factory
    Mobile Phone: 0722 489 607
    bogdan.craciun@asf.ro
    ________________________________________

  • RELEVANCY SCORE 3.13

    DB:3.13:Creating A Due Date Field With Parameter z7



    I need to create a due date field with a parameter. viz need to create a due date for a book issued . due date must be 10 days from date of issue (issue date).

    Help would be appreciated

    DB:3.13:Creating A Due Date Field With Parameter z7


    Hi Bhavesh,

    Sorry to bother you!

    I have a question, what if I want to include 10 business days in this script, instead straight 10 days?

    Thanks!

  • RELEVANCY SCORE 3.13

    DB:3.13:Mandatory Custom Metadata Field With Current System Date As Default Value. 98


    I want to create a custom metadata field of type Date. I want to make it mandatory and want to set its default value as system date.

    I have already created field of type Date. What expression I should write to make system date as default value?

    Because its a mandatory field, what would happen to existing content. Will there metadata get updated?

    Thanks
    Sanjeev

    DB:3.13:Mandatory Custom Metadata Field With Current System Date As Default Value. 98

    Thank you both for replying and $dateCurrent$ works for me.

    Have not tried importing but seems a feasible solution.

    Thanks
    Sanjeev

  • RELEVANCY SCORE 3.13

    DB:3.13:Load File And Date Picker 7d


    Hi, i'm creating an app (XAML C#)and i have a problem.
    The app is and easy ToDo app where if i press a button in the Application Bar it will open a new page where i can select some stuff.
    first question :how do I create a text field
    where when I push open the date picker?
    After thatI use IsolateStorage to create a .txt file into a folder and than when i return in the main page i want that the app load string in the .txt and show it on screen.

    DB:3.13:Load File And Date Picker 7d

    Hi,
    You can browse http://code.msdn.microsoft.com.
    Here
    is a specific search on phone datepicker textbox.
    There, you can open a working project.
    Here
    is a search for IsolatedStorage.
    Hope this helps,
    MarkGetting Started?
    Click here
    Blog: Windows Store & Phone Developer Solutions

  • RELEVANCY SCORE 3.13

    DB:3.13:Date Field s9


    I'd like to have the date automatically placed in the date field when I open a saved blank invoice to create a new one.

    DB:3.13:Date Field s9

    My problem is with Word. Every time I open a file, the date changes to current date. Hope you can help. Wlf

  • RELEVANCY SCORE 3.13

    DB:3.13:Info Structure 7j



    Hi all,

    Where do i create a infostructure in SAP,

    If i want to push a particular field into that infostructure .

    What are the steps involved in creating that infostructure ?

    Regards

    kiran

    DB:3.13:Info Structure 7j


    Hi

    You can do this in the sales information system (sis) mc18, mc21, mc22 all are the transaction codes so please try with this you can go for further process

    if you feel answer solve your query please reward with points

    Thanks Regards

    rack 29

  • RELEVANCY SCORE 3.13

    DB:3.13:Another Date Question... c9



    I push $DATE$ to a Date field in ACTL - and the results are as I expect.I then set the Date field to another Date field in a FLTR and weirdness happens.ACTL - Push $DATE$ to Date field == 21/09/2007FLTR - Set same Date field to another Date field == 20/09/2021I'm in the UK so expect dd/mm/yyy. This is V7.0.1 P3 on Solaris 10.Whatcould behappening here?Regards,John

    DB:3.13:Another Date Question... c9


    Hi,My response is to do the following : FLTR - Set same Date field to another Date field

  • RELEVANCY SCORE 3.13

    DB:3.13:Addm 8.3 Create Sync Tpl Code In A Try Catch Statement c1



    HI all,

    I write a tpl that sync a CI....

    If I don't push required field, after 4 time, sync execute a transaction roll back.

    Can I create a try - catch code for push required field, with custom value, only if sync failed???

    Tnk

    Marco

    DB:3.13:Addm 8.3 Create Sync Tpl Code In A Try Catch Statement c1


    No - there is no such functionality.

    If the push is failing it implies there is something wrong either with the sync mapping, CMDB or CMDB data model.

  • RELEVANCY SCORE 3.13

    DB:3.13:Not In Range Syntax fs


    How do I a create a condition for a field not being in a date range like {field x} not in MonthToDate? Not in does not seem to work.

    DB:3.13:Not In Range Syntax fs

    try thisnot ( in MonthToDate)regards,Raghavendra

  • RELEVANCY SCORE 3.12

    DB:3.12:Variants j9



    Hi,

    I need to create a variant for a selection screen that has a date field.

    The variant should be set in such a manner that this field should always contain the current date, whenever checked.

    Say, I saved the variant on 16.06.2010 with the date as 16.06.2010 in this field.

    The next day, on 17.06.2010, the date field should have the value 17.06.2010 in it and so on.

    Please suggest.

    Regards,

    Binay.

    DB:3.12:Variants j9


    Moderator message - Please search before asking - post locked

    Rob

  • RELEVANCY SCORE 3.12

    DB:3.12:Push Button Set To Calculate Form 9k



    Hi Friends,

    Ive to create calculator by simple form without any data service. Ive modeled form with push button to assign value from one field to another (push button option-action-system action-dynamic-action-formula with correct pass value from one field to another, but it doesn't work, it means field is empty after push button. do you know how to modeled button to put the result to the field? At the moment value puts to field automatically. I want to control this event by button. How?

    Martin

    DB:3.12:Push Button Set To Calculate Form 9k


    Hi Friends,

    Ive to create calculator by simple form without any data service. Ive modeled form with push button to assign value from one field to another (push button option-action-system action-dynamic-action-formula with correct pass value from one field to another, but it doesn't work, it means field is empty after push button. do you know how to modeled button to put the result to the field? At the moment value puts to field automatically. I want to control this event by button. How?

    Martin

  • RELEVANCY SCORE 3.12

    DB:3.12:Date Record Updated In Ms Access 2013 az


    I have a form in Microsoft Access with a date field "Date captured" and the Default Value is "=Date()". I want to create an additional field for "Date Record Updated".

    My question is how do I get a field to automatically display the date that an existing record has been updated.

    Will appreciate help.

    Thank you

    DB:3.12:Date Record Updated In Ms Access 2013 az

    You'll find an example of means of time-stamping a record as ChangedRecordDemo.zip in my public databases folder at:

    https://onedrive.live.com/?cid=44CC60D7FEA42912id=44CC60D7FEA42912!169

    If you have difficulty opening the link copy its text (NB, not the link location) and paste it into your browser's address bar.

    In this little demo file there are options to time-stamp the latest change to a record, or to log changes to a record. The latter may be closer to what you have in mind as the first date/time logged per record will be the 'date captured', i.e when the record
    was created, and subsequent date-times will be when the record was updated. The key thing about this demo, however, is that it only records
    actual changes to data not simply updates. A record can be updated without any values actually changing.

  • RELEVANCY SCORE 3.12

    DB:3.12:Activelink Unable To Pushfield To Cmf:Filterplugin Form fc



    We are creating custom options for the "Operator Actions" drop down menu in CLM. This particular example, we are creating a "Create Baseline" option which in turn will invoke an AO Callout to perform a VMWare Snapshot against the selected Virtual Machine. We have performed the following steps, per BMC best practice, and have been successful so far:1) Create new drop down entry in the CMF:OperatorActions form2) Create new drop down entry in the CMF:LocaleStringOperatorActions form3) Flush the Mid Tier Cache4) Via Developer Studio in Best Practice Customization mode to create overlays and modify fields in the following forms: a. CMF:FilterPlugin form: Added "Create Baseline" to the UIAction_UserFriendlyName field with an ID of 400 b. CMU:ServiceInstances form: Added "Create Baseline" to the UI_OperatorActions field with an ID of 4005) In Developer Studio, create a new display-only form "CMU:OperAction_CreateBaseline" for a dialog box that enables the user to click "Start" to start the snapshot process.6) The "Start" button on step above invokes ActiveLink "CMU:OperAction_CreateBaseline-ActiveLink-CreateButton". This Active Link is performing a PushField with the set of required fields to the CMF:FilterPlugin form.7) Flush midtier cache.The problem we are having is that once that option is invoked from the CLM interface, we get an error:Required field cannot be blank. :304253630 (ARERR 326)The field ID in the error form is related to the UIAction_UserFriendlyName field. We enabled ActiveLink debug for the user performing this action, and we confirm that a value is being passed:

    action 0

    Push-fields 2 = Demo

    Push-fields 7 = 0

    Push-fields 8 = GUID

    Push-fields 112 = 1000000006

    Push-fields 304252670 = CMU:ServiceInstances

    Push-fields 304252700 = POST

    Push-fields 304252710 = com.bmc.cloud.model.beans.ComputeContainer

    Push-fields 304252720 = 3d943191-9149-4e56-a378-8e9e6a4cf4ac

    Push-fields 304252730 = executeScript

    Push-fields 304252740 = scriptName=snapshot:#:scriptParams=NCPS BASELINE

    Push-fields 304252750 = 123456789

    Push-fields 304253630 = 400

    Push-fields 304253640 = 110

    Push-fields 304262940 = en_US

    Anyone successfully done this?

    Thanks,

    Vinnie

    DB:3.12:Activelink Unable To Pushfield To Cmf:Filterplugin Form fc


    But how do you distinguish between one operator action and it's related workflow, and another (e.g. VirtualGuest_EXECUTESCRIPT to perform a snapshot, versus one that is to Add a VMDK)?

  • RELEVANCY SCORE 3.11

    DB:3.11:Create A Date Field m3



    Hi guys!!!

    I need some help...

    I have three Qvds.By concatenating them I am geting a single table.Month and Year fields are present...but there is no date field (Day field).Data is geting uploaded on regular basis.I want to add a date field so that the user can see the difference between toady's data nd yesterday's data.

    DB:3.11:Create A Date Field m3


    Hi Erika,

    I see two different things here: in one hand the "incremental" load based on some timestamp that is not in your database and depends on when the files are loaded and on the other hand the date dimensions used later in your charts and expressions.

    In regards to the code

    MonthName(MakeDate(NewYear, Daily.FinMonth, day(reloadtime())), 3) AS DailyDashboardMonthYear

  • RELEVANCY SCORE 3.11

    DB:3.11:Date Validation dc


    I had to cut a date field into 3 pieses ( [day] [month] [year] )Now i have to validate the date, but i don't know how.I create a script to combine the field values into a new hidden field to perform te validation.event.value = vDay.value + "-" + vMonth.value + "-20" + vYear.value;

    DB:3.11:Date Validation dc

    @try67Works perfect.Just what i'm looking forThank you

  • RELEVANCY SCORE 3.11

    DB:3.11:Partial Field Extract mm


    My user is putting date and time information in a text field
    instead of the normal date/time field type.

    My question is that I need to create two fields from the 20
    position field. The DateFormat function does not work because there
    is extra data at the end of the field makinig it an Invalid Date
    Format. The first 8 text characters (yyyymmdd) need to go into one
    newly created field while position 9-14 (hhmmss) need to go into
    another newly created field.

    What function handles this?

    Thanks

  • RELEVANCY SCORE 3.11

    DB:3.11:Adding Days To Date Field During Load 8c



    I have a date field that is loaded called [Sched Complete Date]. Sometimes the field is blank (and it messes up some of my formulas). What I want to do is, when the Sched Complete Date is empty, add 45 days from another field in data; Create Date. Example:

    Create Date = 1/1/2014

    Sched Complete Date is updated to 2/14/2014

    I can't figure out the structure of the "IF/Then" statement.

    Thanks for any help.

    Jeff

  • RELEVANCY SCORE 3.11

    DB:3.11:Date Of Manufacture In Exit_Sapmm07m_003 z9



    Hi,

    Is it possible to create date of manufacture in EXIT_SAPMM07M_003.Which field should I use ?

    Thanks

  • RELEVANCY SCORE 3.11

    DB:3.11:Using Entry.Clone() In Java Api - Is It Useful? zm



    I'm trying to create a new entry based on another by using the clone method. This makes a verbatim copy of the object rather than (as would be useful) updating the instance ID and other unique information such that the entry can actually be saved to the server. Am I right in concluding that clone() is more of a programming construct and is not really intended to facilitate the copying of actual records? I tried removing all the unique fields from the entry before creation but then it complains that a required field is missing. For example, below you see all the fields that it complained about the first time being unique so I'm removing them from the Entry. Then it complains that the required field "Infrastructure Change ID" is not that's what i'm trying to get - a new Change ID record!

    Apr 21 16:28[r.ars.arscmd:setEntitiesToWorkOn]FINE found 1 entities to wor
    k on
    Removing field: Actual Cost Static Total
    Removing field: Budget Cost Static Total
    Removing field: Budget Cost (Currency)
    Removing field: Actual Cost (Currency)
    Removing field: Status History
    Removing field: Last Modified Date
    Removing field: Last Modified By
    Removing field: Submit Date
    Removing field: Request ID
    Removing field: Infrastructure Change ID
    Removing field: Location Company
    Removing field: Support Group ID
    Removing field: ASGRPID
    Removing field: CAB Manager Login
    Removing field: Change Request Status
    Removing field: Request Number
    Removing field: InstanceId
    Removing field: Actual Start Date
    Removing field: Scheduled Start Date
    Removing field: Requested Start Date
    Problem cloning record
    Unable to create a clone: ERROR (307): Required field (without a default) not sp
    ecified; 1000000182

    DB:3.11:Using Entry.Clone() In Java Api - Is It Useful? zm


    I'm trying to create a new entry based on another by using the clone method. This makes a verbatim copy of the object rather than (as would be useful) updating the instance ID and other unique information such that the entry can actually be saved to the server. Am I right in concluding that clone() is more of a programming construct and is not really intended to facilitate the copying of actual records? I tried removing all the unique fields from the entry before creation but then it complains that a required field is missing. For example, below you see all the fields that it complained about the first time being unique so I'm removing them from the Entry. Then it complains that the required field "Infrastructure Change ID" is not that's what i'm trying to get - a new Change ID record!

    Apr 21 16:28[r.ars.arscmd:setEntitiesToWorkOn]FINE found 1 entities to wor
    k on
    Removing field: Actual Cost Static Total
    Removing field: Budget Cost Static Total
    Removing field: Budget Cost (Currency)
    Removing field: Actual Cost (Currency)
    Removing field: Status History
    Removing field: Last Modified Date
    Removing field: Last Modified By
    Removing field: Submit Date
    Removing field: Request ID
    Removing field: Infrastructure Change ID
    Removing field: Location Company
    Removing field: Support Group ID
    Removing field: ASGRPID
    Removing field: CAB Manager Login
    Removing field: Change Request Status
    Removing field: Request Number
    Removing field: InstanceId
    Removing field: Actual Start Date
    Removing field: Scheduled Start Date
    Removing field: Requested Start Date
    Problem cloning record
    Unable to create a clone: ERROR (307): Required field (without a default) not sp
    ecified; 1000000182

  • RELEVANCY SCORE 3.10

    DB:3.10:Strange Behaviour Of Data Field In Monthly Invoice. fz



    Dear all,

    I need to create new layout for monthly invoice using Print Layout Designer. I need to add the closing date procedure code, so I create new data field refering to the Closing Date Procedure file. This first data field shows many files. But when I want to add another new data field, this second data field only shows the Administration and Closing Date Procedure file. I need to add field from other file, but it does not appear.

    If I delete the second data field, I can find the file I need in the first data field (the one supposed to be fill with closing date procedure code).

    Is there any idea how to get other files in the second data field ?

    By the way, I am using SBO version 2004.2b for Japanese user, and monthly invoice is an important function in Japan.

    Thank you very much,

    Emiliana

  • RELEVANCY SCORE 3.10

    DB:3.10:Aie:Log Form's "Log Entry Date" Field Vs Create Date 9j



    Unable to find the documentation that defines the "Log Entry Date" on the AIE:Log.

    Thought it was when the record was created (like create date) but the dates are not the same.

    What is this field used for?

    Thanks!

    Hannah

    DB:3.10:Aie:Log Form's "Log Entry Date" Field Vs Create Date 9j


    Its a timestamp on AIE host box , so what it means is if AR and AIE are on a different host having different times then the LogEntryDate will log the timestamp of AIE host box and hence CreateDate and the logEntryDate will be different.

    -Thanks

    Yogesh

  • RELEVANCY SCORE 3.10

    DB:3.10:Workflow Not Working W/Calculated Field cd


    I am trying to create a workflow that will push out an email X number of days from an expiration date. I have created the following fields in my document library:
    Expiration Date - actual expiration date
    Expiration Days - number of days before expiration date to send email
    Calculated - Expiration date - expiration days
    The resulting field in 'Calculated' displays a date, however when I try to reference it in my workflow, it shows up as 'Pausing for 90768.001922 minutes' rather than pausing until that day.
    Does anyone know of a better way to do this in BPOS? I would be happy to redesign my workflow if there's an easier way. I'd use the expiration policy, but I need to specify different due/reminder dates based on what documents are uploaded. Help is much appreciated,
    and please let me know if there's anything I can clarify!

    DB:3.10:Workflow Not Working W/Calculated Field cd

    I ultimately ended up using a new calculated field to calculate the number of days I want to pause the workflow:
    [End date]-[reminder date]
    Then referenced that in my workflow using 'Pause for X days'
    Do you anticipate any issues with this workflow? Is there any risk in doing this in a document library? I have heard of lag causing a workflow not to fire if you don't put the fields in quick enough after uploading a file. Any way around this?

  • RELEVANCY SCORE 3.09

    DB:3.09:How To Create A Field In Dictionary Table Without Making Changes In Form Layout 83



    Hi All,

    There is a date time field to be created which is used for reporting purpose.This field should not be on the form layout.

    When i try to create it through dictionary,the form layout is also updated with the field which is not required.

    DB:3.09:How To Create A Field In Dictionary Table Without Making Changes In Form Layout 83


    Hi Lakshmi,

    If you are creating fields in table means you are also adding fields in the form of that particular table. When you create a field in table the form will change means the form layout(form with extra field) will change.so in this case update set will have only one record related to form layout of that particular table.

    If you are creating 2 fields in incident table then also update set will have only one record related to form layout which will be the modified form layout record of incident table.

    If you dont want to show the same field in form then you can do by editing the form layout.

    Thanks,

    Pavan

  • RELEVANCY SCORE 3.09

    DB:3.09:Calculating An Age pc


    I want to create a field that automatically calculates someones age.
    So I have a Date Of Birth field, and a Current Date field, plus a field that subtracts one from the other. The problem is it gives the answer in weeks (ie 2408 weeks.) How do it get it to give years and months?
    Thanks!

    DB:3.09:Calculating An Age pc

    Hi Jerry - thanks for that; you clearly know you're way round spreadsheets!
    Can I ask you to make an amendment to your answer?
    I don't always want to calculate the answer from todays date:
    So...
    Cell A1 = Date of birth
    Cell B1 = Date (to be input)
    Cell C1 = RESULT

    Many thanks,
    Andy

  • RELEVANCY SCORE 3.09

    DB:3.09:Wd Date/String Input Field ck


    Hi all,My question is:Is it possible to create String input field, which contains simple date navigator (like input field of "date" type)? I want use it for user comfort - he/she can pick-up date from date navigator, but he/she can type another strings {, =, ... } before or after selected date. Or, in another way, is it possible to get String value of Date Input Field?Regards,Michal

    DB:3.09:Wd Date/String Input Field ck

    1.Add one button adjacent to input field.2.Add a DateNavigator element to the view.3.Map it visible property to one context value attribute.4.On click of button set above value attribute to visible.5.On click of date navigator set value of input field and set visible value attibute to none.

  • RELEVANCY SCORE 3.09

    DB:3.09:Oracle Error Message Code 1401 Op 4, Ora-01401: Inserted Value Too Large Fo dp


    Hi All

    I got this error when I try to run convert tables on our application server. Anyone know why? I am using Oracle 9i

    Here is the error message:

    Checking Table WORK_INSTRUCTION
    Table not in database
    Conversion Method - Create Table
    Creating Table WORK_INSTRUCTION
    Unable to create database table 'WORK_INSTRUCTION'
    Oracle error message code 1401 op 4, ORA-01401: inserted value too large for column

    WORK_INSTRUCTION definition as followings:

    table work_instruction;

    field identity
    used_for unique_key
    datatype identity;

    { APR 31/3/03 - Bug Nr WI4}
    field wi_admin
    { links_to personnel . identity;}
    { links_to location . identity;}
    links_to lab_section . identity;

    { ARP 31/3/03 - Bug Nr WI5 }
    field wi_title
    { datatype text(20); }
    datatype text(100);

    field version
    datatype text ( 4 );

    field wi_status
    datatype identity
    prompt_type choose
    choose_type WI_STATUS
    default 'I ' ;

    field wi_type
    datatype identity
    prompt_type choose
    choose_type WI_TYPE
    default '0 ';

    field sterlab_status
    datatype identity
    prompt_type choose
    choose_type STER_STAT
    default '0 ';

    field used_in_lims
    datatype boolean
    true_word 'Yes'
    false_word 'No'
    default 'No' ;

    { ARP WI16 28/5/03 - Extend from 10 to 45 }
    field method
    datatype text(45);

    field ref_method
    datatype text(100);

    field delegate
    links_to personnel . identity;

    field date_expire
    datatype date;

    field date_draft
    datatype date;

    field double_method
    datatype boolean
    true_word 'Yes'
    false_word 'No'
    default 'No' ;

    field technique
    datatype identity
    prompt_type choose
    choose_type TECHNIQUE
    default '0 ';

    field date_distribute
    datatype date;

    field report_date
    datatype date;

    field group_autho
    datatype text ( 16 );

    field astm_volume
    datatype text ( 6 );

    field date_non_active
    datatype date;

    field translated_in
    datatype text(10);

    { ARP WI16 28/5/03 - Extend from 60 to 2000 }

    field comments
    datatype text(2000);

    field doc_path
    datatype text ( 300 )
    prompt_type user_defined
    library 'TEST_SOP_FILE'
    routine 'file_browse';

    field modified_on
    datatype date
    used_for modified_on ;

    field modified_by
    links_to personnel.identity
    used_for modified_by;

    field modifiable
    datatype boolean
    used_for modifiable;

    field removeflag datatype boolean
    used_for remove_flag;

    { MOD TDR - 10/04/03 - Link to livelink document }
    field livelink_url
    datatype text ( 300 ) ;

    Thanks

    Li

    DB:3.09:Oracle Error Message Code 1401 Op 4, Ora-01401: Inserted Value Too Large Fo dp

    Verbatim from the manual:
    ORA-01401:inserted value too large for column
    Cause:The value entered is larger than the maximum width defined for the column.
    Action:Enter a value smaller than the column width or use the MODIFY option with ALTER TABLE to expand the column width.You should find which value is bein attempted to be inserted into a column with a capacity shorter than the value length.

    ~ Madrid.

  • RELEVANCY SCORE 3.09

    DB:3.09:Crm Online - Calculate Date Field c1


    Hi,

    I need to create a field that calculates the Birthday field into a new field called age.
    example:
    Birthday = 22/04/1980
    Age = 33 years old = (22/07/2013 - 22/07/1980)

    How do?
    thank you,

    DB:3.09:Crm Online - Calculate Date Field c1

    Hi,

    I need to create a field that calculates the Birthday field into a new field called age.
    example:
    Birthday = 22/04/1980
    Age = 33 years old = (22/07/2013 - 22/07/1980)

    How do?
    thank you,

  • RELEVANCY SCORE 3.09

    DB:3.09:Getting Age From Date Field x8


    Possible?

    DB:3.09:Getting Age From Date Field x8

    Thanks - works perfectley!

    http://members.lycos.co.uk/premierleaguestats/age_test.php

  • RELEVANCY SCORE 3.09

    DB:3.09:Select From Xml zz



    my_dati2.xml?xml version=1.0 encoding=ISO-8859-1 ?form_job form_section field name=FLOWLEVEL1/field field name=FLOWACTION_0RICHIESTA/field field name=DATA1_0/field field name=TIPO_0Il sottoscritto/field field name=TIPOFERIE_0FERIE/field field name=ANNO_0/field field name=NOMINATIVO_0shevi/field field name=SETTORE_0Amministrazione/field field name=DESTINATARIO_0aa@aa.it/field field name=MITENTE_0/field field name=USERNAMEshavonne/field form name=001FERIE2 subform_group subform name=FERIE3 field name=DATA2_001/01/2005/field field name=DATA3_002/02/2005/field field name=GIORNO_03/field field name=DATA4_003/03/2005/field field name=ORE1_09.00/field field name=ORE2_010.00/field field name=ORE3_011.00/field /subform /subform_group /form /form_section/form_jobMy asp Page ^^%Dim objXMLDIm objSubFormNameDIm objSubFormNameListDim objSubFieldDim objSubFieldListDim connDim strSQLDim SubTableNameDim SubFieldNameDim SubFieldValueDim strValues(512)Dim iSet objXML = Server.CreateObject(MSXML2.FreeThreadedDOMDocument)objXML.async = FalseobjXML.setProperty ServerHTTPRequest, TrueobjXML.Load(Server.MapPath(my_dati2.xml))' Get form Name from the XMLSet objSubFormNameList = objXML.getElementsByTagName(subform)For Each objSubFormName In objSubFormNameList SubTableName = objSubFormName.getAttribute(name)NextResponse.write Subform Name SubTableName br' Get field Names and Values from the XML Set objSubFieldList = objXML.getElementsByTagName(field) Set objXML = NothingstrFields = strData = i = 0For Each objSubField In objSubFieldList' Gets Field Names SubFieldName = objSubField.getAttribute(name) If Len(strFields)0 Then strFields=strFields, strFields = strFields SubFieldName MEMO Response.write SubFieldName br' Gets Field Values SubFieldValue = objSubField.text strValues(i) = SubFieldValue i = i + 1Next'Connecting to the databaseSet conn = Server.CreateObject(ADODB.Connection)conn.Open(DRIVER={Microsoft Access Driver (*.mdb)}; DBQ= server.MapPath(mydb.mdb)) Set oRs = Server.CreateObject(ADODB.Recordset )'Checks if the table already existson error resume nextstrSQL = SELECT * FROM SubTableNameoRs.Open strSQL,conn,2,3If err 0 then'It doesn't exists'1 Create the table, 2 Create the fields, 3 Insert the values strSQL = CREATE TABLE SubTableName ( strFields , (DATA_INSERITO DATE) , (ORA_INSERITO TIME) ) Response.write strSQL conn.Execute strSQL Response.write table created br oRs.open SubTableName,conn oRs.addnew For i = 0 to oRs.Fields.Count oRs(i) = strValues(i) Next oRs(DATA_INSERITO)=DATE() 'The system date the record was inserted oRs(ORA_INSERITO)=TIME() 'The system time the record was inserted oRs.update oRs.close conn.Execute strSQLElse'It exists'1 Insert the values Response.write table exists br oRs.open SubTableName,conn oRs.addnew For i = 0 to oRs.Fields.Count oRs(i) = strValues(i) Next oRs(DATA_INSERITO)=DATE() 'The system date the record was inserted oRs(ORA_INSERITO)=TIME() 'The system time the record was inserted oRs.update oRs.close conn.Execute strSQL End If%
    My problem

    If you look at the partFor Each objSubField In objSubFieldList' Gets Field Names SubFieldName = objSubField.getAttribute(name) If Len(strFields)0 Then strFields=strFields, strFields = strFields SubFieldName MEMO Response.write SubFieldName br' Gets Field Values SubFieldValue = objSubField.text strValues(i) = SubFieldValue i = i + 1Next
    gives me a list of all the fields in the xml.

    FLOWLEVEL
    FLOWACTION_0
    DATA1_0
    TIPO_0
    TIPOFERIE_0
    ANNO_0
    NOMINATIVO_0
    SETTORE_0
    DESTINATARIO_0
    MITENTE_0
    USERNAME
    DATA2_0
    DATA3_0
    GIORNO_0
    DATA4_0
    ORE1_0
    ORE2_0
    ORE3_0

    But i want it to select only the fields that are inside the tags subform_group subform name=FERIE3 field name=DATA2_001/01/2005/field field name=DATA3_002/02/2005/field field name=GIORNO_03/field field name=DATA4_003/03/2005/field field name=ORE1_09.00/field field name=ORE2_010.00/field field name=ORE3_011.00/field /subform /subform_group
    So i would get something like this for the response write

    DATA2_0
    DATA3_0
    GIORNO_0
    DATA4_0
    ORE1_0
    ORE2_0
    ORE3_0

    Any idea??

    Thank you

    DB:3.09:Select From Xml zz


    my_dati2.xml?xml version=1.0 encoding=ISO-8859-1 ?form_job form_section field name=FLOWLEVEL1/field field name=FLOWACTION_0RICHIESTA/field field name=DATA1_0/field field name=TIPO_0Il sottoscritto/field field name=TIPOFERIE_0FERIE/field field name=ANNO_0/field field name=NOMINATIVO_0shevi/field field name=SETTORE_0Amministrazione/field field name=DESTINATARIO_0aa@aa.it/field field name=MITENTE_0/field field name=USERNAMEshavonne/field form name=001FERIE2 subform_group subform name=FERIE3 field name=DATA2_001/01/2005/field field name=DATA3_002/02/2005/field field name=GIORNO_03/field field name=DATA4_003/03/2005/field field name=ORE1_09.00/field field name=ORE2_010.00/field field name=ORE3_011.00/field /subform /subform_group /form /form_section/form_jobMy asp Page ^^%Dim objXMLDIm objSubFormNameDIm objSubFormNameListDim objSubFieldDim objSubFieldListDim connDim strSQLDim SubTableNameDim SubFieldNameDim SubFieldValueDim strValues(512)Dim iSet objXML = Server.CreateObject(MSXML2.FreeThreadedDOMDocument)objXML.async = FalseobjXML.setProperty ServerHTTPRequest, TrueobjXML.Load(Server.MapPath(my_dati2.xml))' Get form Name from the XMLSet objSubFormNameList = objXML.getElementsByTagName(subform)For Each objSubFormName In objSubFormNameList SubTableName = objSubFormName.getAttribute(name)NextResponse.write Subform Name SubTableName br' Get field Names and Values from the XML Set objSubFieldList = objXML.getElementsByTagName(field) Set objXML = NothingstrFields = strData = i = 0For Each objSubField In objSubFieldList' Gets Field Names SubFieldName = objSubField.getAttribute(name) If Len(strFields)0 Then strFields=strFields, strFields = strFields SubFieldName MEMO Response.write SubFieldName br' Gets Field Values SubFieldValue = objSubField.text strValues(i) = SubFieldValue i = i + 1Next'Connecting to the databaseSet conn = Server.CreateObject(ADODB.Connection)conn.Open(DRIVER={Microsoft Access Driver (*.mdb)}; DBQ= server.MapPath(mydb.mdb)) Set oRs = Server.CreateObject(ADODB.Recordset )'Checks if the table already existson error resume nextstrSQL = SELECT * FROM SubTableNameoRs.Open strSQL,conn,2,3If err 0 then'It doesn't exists'1 Create the table, 2 Create the fields, 3 Insert the values strSQL = CREATE TABLE SubTableName ( strFields , (DATA_INSERITO DATE) , (ORA_INSERITO TIME) ) Response.write strSQL conn.Execute strSQL Response.write table created br oRs.open SubTableName,conn oRs.addnew For i = 0 to oRs.Fields.Count oRs(i) = strValues(i) Next oRs(DATA_INSERITO)=DATE() 'The system date the record was inserted oRs(ORA_INSERITO)=TIME() 'The system time the record was inserted oRs.update oRs.close conn.Execute strSQLElse'It exists'1 Insert the values Response.write table exists br oRs.open SubTableName,conn oRs.addnew For i = 0 to oRs.Fields.Count oRs(i) = strValues(i) Next oRs(DATA_INSERITO)=DATE() 'The system date the record was inserted oRs(ORA_INSERITO)=TIME() 'The system time the record was inserted oRs.update oRs.close conn.Execute strSQL End If%
    My problem

    If you look at the partFor Each objSubField In objSubFieldList' Gets Field Names SubFieldName = objSubField.getAttribute(name) If Len(strFields)0 Then strFields=strFields, strFields = strFields SubFieldName MEMO Response.write SubFieldName br' Gets Field Values SubFieldValue = objSubField.text strValues(i) = SubFieldValue i = i + 1Next
    gives me a list of all the fields in the xml.

    FLOWLEVEL
    FLOWACTION_0
    DATA1_0
    TIPO_0
    TIPOFERIE_0
    ANNO_0
    NOMINATIVO_0
    SETTORE_0
    DESTINATARIO_0
    MITENTE_0
    USERNAME
    DATA2_0
    DATA3_0
    GIORNO_0
    DATA4_0
    ORE1_0
    ORE2_0
    ORE3_0

    But i want it to select only the fields that are inside the tags subform_group subform name=FERIE3 field name=DATA2_001/01/2005/field field name=DATA3_002/02/2005/field field name=GIORNO_03/field field name=DATA4_003/03/2005/field field name=ORE1_09.00/field field name=ORE2_010.00/field field name=ORE3_011.00/field /subform /subform_group
    So i would get something like this for the response write

    DATA2_0
    DATA3_0
    GIORNO_0
    DATA4_0
    ORE1_0
    ORE2_0
    ORE3_0

    Any idea??

    Thank you

  • RELEVANCY SCORE 3.09

    DB:3.09:Field To Highlight Specified Record From Portal sx



    I have a portal with a date field and a number field. I am trying to create a field that displays the number from the record with the most recent date where the number field is not empty. Ideas? thanks.

    DB:3.09:Field To Highlight Specified Record From Portal sx


    I've run into trouble before with NOT NULL / NULL, so I always test for multiple versions in my scripts.

    If someone clears a value out of the field, it's not necessarily "NULL", it's just empty. If you wanted more insight into this, Beverly Voth is the person who tipped me off to this issue, you might want to track her down to consult with you. When I was running into this issue it was with a fairly large record set, with a ridiculous calculation inside of ExecuteSQL(), this by comparison is simple and you might never need to test for multiple conditions with ( OR )

    You might need to replace your not equals sign with either != or , I'm not sure if ExecuteSQL respects the symbol.

  • RELEVANCY SCORE 3.09

    DB:3.09:Trigger - Show Only Null Values For A Date Field d9



    Hi,

    I have a field (fully_paid_dt) and I want to create a sheet trigger to only show where the field is blank. Currently the field displays a - if there is no date populated.

    Any help with the above will be much appreciated.

    Regards,

    Daniel

  • RELEVANCY SCORE 3.09

    DB:3.09:Validation For A Field Based On Two Conditions sm


    I would like to set a validation rule for a field based on the value of two existing fields. I want a date field to be mandatory when the phase (custom) field reads as anything but URS and also at the same time the state field reads as Resolved using the when and when not options for a field. Is there a way to use the conditions in such a manner. Also when I create a date time field, what can be done to display only the date part of it and not the part?

    DB:3.09:Validation For A Field Based On Two Conditions sm

    Assume we have the following fields...

    FIELD refname=Microsoft.Phase name=Phase type=String
    ALLOWEDVALUES
    LISTITEM value=Dummy1 /
    LISTITEM value=URS /
    LISTITEM value=Dummy2 /
    /ALLOWEDVALUES
    /FIELD

    FIELD refname=Microsoft.SampleDate name=Date type=DateTime
    /FIELD

  • RELEVANCY SCORE 3.09

    DB:3.09:Form Field Code For Specific Date Calculation 9m


    I created a form using field codes. I need to see if there is a way to create a field that will automatically insert the currrent date plus 10 days. So instead of 11/22/10 it would be 12/3/2010. Right now its just a text form field that has to be manually
    entered.

    DB:3.09:Form Field Code For Specific Date Calculation 9m

    Hi Kmill74,
    To see how to do this and just about everything else you might want to do with dates in Word, check out my Microsoft Word Date Calculation Tutorial, at:
    http://lounge.windowssecrets.com/index.php?showtopic=249902
    or
    http://www.gmayor.com/downloads.htm#Third_party
    In particular, look at the item titled 'Date and Time Calculations In A Word Form'. Do read the document's introductory material.

    Cheers,
    macropod MS MVP - Word

  • RELEVANCY SCORE 3.08

    DB:3.08:Date Field With Calendar Option In Oaf Page 9d


    How to create DATE field along with Calendar in already existing Page.

    Please provide the steps.

    DB:3.08:Date Field With Calendar Option In Oaf Page 9d

    Hey hi there ,

    You can create an new item by personalization , follow the below steps

    Click on personalization link on oaf page , please select complete view , Identify the region in which you would like to display the
    new date field , click on create item image it will take you to new page and enter the following details

    Level : Site
    Item style : Message text input
    ID : Some unique id
    Data type : DATE
    Prompt : some appropriate name

    Click on apply , and go back to the page , and now notice that new field with data type as date will get appear on the page .

    We need not set any additional property to get the calender pop up , frame work will take care of everything .

    Let me know if its not clear .

    --Keerthi

  • RELEVANCY SCORE 3.08

    DB:3.08:Calculated Date Field Based On Another Date Field 1k



    Seems like a simple question. I'm looking to have a calculated date field that is based on another date field.

    Date Field 1 = some date

    Date Field 2 (calculated) = Date Field 1 + 2 years

    Could someone help my brain out this morning?

    Thanks

    DB:3.08:Calculated Date Field Based On Another Date Field 1k


    Hi John,

    The addYears function (and similar functions) have no return value. They actually manipulate the internal GlideDate/GlideDateTime value stored with the original variable. So you should use it as follows:

    var gdt = new GlideDateTime(current.u_last_upgrade_date);
    gdt.addYears(2);
    answer = gdt;

  • RELEVANCY SCORE 3.08

    DB:3.08:Calculated Field Type? 3x


    I have created a Date Field in schema file. How I dont know how to create calculated Field based on From date field ?
    Field ID={fa564e0f-0c70-4ab9-b863-0177e6ddd247}
    Name=From
    DisplayName=From
    Sealed=TRUE
    Type=DateTime
    /
    Do I need to create another Field Type of Calculated?Jamsbond

    DB:3.08:Calculated Field Type? 3x

    You should also add ResultType in the attribute of Field Name
    Field ID={fa564e0f-0c70-4ab9-b863-0177e6ddd247}
    Name=From
    DisplayName=From
    Sealed=TRUE
    Type=DateTime
    ResultType=Number
    Formula=[MyOtherField1]-[MyOtherField2]/Formula
    FieldRefs
    FieldRef Name=MyOtherField1 /
    FieldRef Name=MyOtherField2 /
    /FieldRefs
    /Field

    Ray Liu

  • RELEVANCY SCORE 3.08

    DB:3.08:Need A Calculated Field In My Template 31


    Hi there,

    is it possible to have a calculated field in my template. Is the calculated field valid when I create an IO based on the BD that has the calculated field.

    My point is:

    - Need a field to calculate the day average between two dates (like start date and end date) of different records.

    Is it the best way to do it? a calculated field? Thanks.

    Regards,

    DB:3.08:Need A Calculated Field In My Template 31

    Thanks Tim,

    I have now another question:

    anyone knows if it's possible to use a VBC in IO? And call fields from this VBC to create BIP templates?

    regards,

    Nuno