1 Reply Latest reply on Oct 4, 2011 2:20 PM by philmodjunk

    help with setting a field to copy from a variable field

    matronryan

      Title

      help with setting a field to copy from a variable field

      Post

      I'm going to show how new I am to all of this but any help will be gratefully recieved. I have a script that i use to populate my charity DB's monthly standing orders.  The script seems to be working fine apart from one bit. The script creates portal records for all the standing orders for that month.  In each portal record there is a Banked field (this is a date field). for each record I'm trying to set a variable field (SOBanked) by taking the Standing Order day of the month (field in the donors record) and the month and year from the parent record event date.  But when the script is finished Banked field has a ? in it.  I've attached an image of my script

      ANY HELP would be great

       

      Thanks

       

      Screen_Shot_2011-10-04_at_22.05.09.png

        • 1. Re: help with setting a field to copy from a variable field
          philmodjunk

          USe either of these two options.

          Enclose the expression in the highlighted step with:

          GetAsDate ( //Your expression here )

          Or use the date function:

          Date ( Doner Detail::Standing Order Day of the Month ; Month (Main::eventDate ) ; Year ( Main::event_Date ) )

          Dates are stored as integers that count the number of days since 12/31/0000 not as text so you have to convert the text form of your date into that number.