topic Creating a Time Stamp Field in QlikView

Creating a Time Stamp Field

Wed, 01 Apr 2015 14:56:35 GMT

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?

Re: Creating a Time Stamp Field

rubenmarin — Wed, 01 Apr 2015 15:00:36 GMT

Hi Andrea, just:

Today() as InventoryDate;

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

Re: Creating a Time Stamp Field

Wed, 01 Apr 2015 15:04:03 GMT

Thank you! I was over-complicating it!