Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date Qlikview

Hello good day,

I would like to know how can a database that has a date field, declare a variable of type date to assign to that field and is updated every day to recharge.

Example

Let Date1= Date(Today())

3 Replies
swuehl
MVP
MVP

Not sure what you are trying to achieve.

Let Date1 = Date(Today());

will assign today's date to variable Date1. What do you want to do with this variable with regard to the database date field?

eduardo_sommer
Partner - Specialist
Partner - Specialist

Hi Angel,

If you want to include a field in a table, with today's date as it's content, include the line

Set TodayDate=today();

and in the load statement of the table, include the following line

Load ...

        ...

        $(TodayDate) as TodayDateField,

       ...

Is that what you were looking for?

Regards

Eduardo

engishfaque
Specialist III
Specialist III

Dear Angel,

Please use "LET DATE = Date(Today());" in your edit script tab "Main".

Whenever your script will reload, DATE variable will automatically update with Today date.

Kind regards,

Ishfaque Ahmed