Creating a Time Stamp Field

[#1]

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:

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

[rubenmarin · Accepted solution]

Hi Andrea, just:

Today() as InventoryDate;

or

Date(Today(), 'DateFormatYouWant') as InventoryDate;

[#3]

Thank you! I was over-complicating it!