topic Re: Date Field Calculation in QlikView

Date Field Calculation

Thu, 18 Sep 2014 13:21:20 GMT

Hi All

I would like to have a field that automatically calculates a date based on the amount of years in the [Years] field.

e.g 18/09/2014 + 2 years (I want the result to be in a date format dd/mm/yyyy). How can I do this?

Anonymous — Thu, 18 Sep 2014 13:27:18 GMT

You can use function AddYears:

AddYears(YourDateField, NumOfYears)

rubenmarin — Thu, 18 Sep 2014 13:28:47 GMT

Hi Tumelo, cCan you try?:

AddMonths(DateField, YearsField * 12)

jagan — Thu, 18 Sep 2014 13:34:23 GMT

Hi,

Try like this

LOAD

AddYears(DateFieldName, YearsFieldName) AS NewDate

FROM DataSource;

Regards,

Jagan.

Thu, 18 Sep 2014 13:46:44 GMT

Hi All. Thanks a lot for replies, very helpful indeed. All Answers are correct. Pitty we can only mark one... 🙂