Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi Andrea, just:
Today() as InventoryDate;
or
Date(Today(), 'DateFormatYouWant') as InventoryDate;
Hi Andrea, just:
Today() as InventoryDate;
or
Date(Today(), 'DateFormatYouWant') as InventoryDate;
Thank you! I was over-complicating it!