Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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?

Tags (3)
1 Solution

Accepted Solutions

Re: Creating a Time Stamp Field

Hi Andrea, just:

Today() as InventoryDate;

or

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

2 Replies

Re: Creating a Time Stamp Field

Hi Andrea, just:

Today() as InventoryDate;

or

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

Not applicable

Re: Creating a Time Stamp Field

Thank you! I was over-complicating it!

Community Browser