2 Replies Latest reply on Aug 8, 2010 8:31 AM by Joseph07888

    NOW_DT & NOW funtions don't work together

    Joseph07888

      Hi All,

       

      I have an issue with the {NOW_DT} & {NOW} funtions

       

      In my registration form i have fields for timestamp and date.

       

      The timestamp is for any updates made to the profile and the date is to specify the date of registration.

       

      But when they are submitted on the {NOW_DT} works leaving the {NOW} null in the DB.

       

      They are both submitted as FORM VARIABLE's with the defaults {NOW_DT} & {NOW} in the insert transaction.

       

      Can anyone shed any light on why they won't work together?

       

      Cheers,

      Joe

        • 1. Re: NOW_DT & NOW funtions don't work together
          Günter Schenk Level 4

          Joseph07888 wrote:

           

          They are both submitted as FORM VARIABLE's...

          Assuming that you´re using hidden fields for this, the first step to help tracing the possible error is to have your browser show the source code of the generated page and check whether both hidden fields display the {NOW_DT} respectively {NOW} values in the "value" attribute of these elements, or if one is missing.

           

          Cheers,

          Günter

          • 2. Re: NOW_DT & NOW funtions don't work together
            Joseph07888 Level 1

            Hi Gunter,

             

            I hope you're well!

             

            I changed to the way you suggested and it has fixed the issue.

             

            I did however find that I had to use the format date function or if there was a form error the date would become wrong.

             

            But thanks again and look forward to speaking with you again soon.

             

            Also I am launching version of my online business and event marketing directory internationally in September and looking for helpers to test in other countries.

             

            you can register at www.eventmanagementmarketing.com

             

            Cheers,

            Joe