2 Replies Latest reply: Apr 1, 2015 11:04 AM by Andii Toole RSS

    Creating a Time Stamp Field

      I have data that I am pulling daily but doesn't have a date or timestamp or anything associated with it. I'm trying to create a field that has the date for the day it is loaded - but I can't seem to get it to work.

       

      Currently I have:

                        Date(MakeDate(Today())) as InventoryDate;

       

      But instead of giving me one form of a date or another - this is what that pulls:

       

      Snip.JPG

       

      Does anyone have any suggestions on how I can either modify my existing script or create this field with another function?