Date Field Calculation

[#1]

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 · Accepted solution]

You can use function AddYears:

AddYears(YourDateField, NumOfYears)

[rubenmarin]

Hi Tumelo, cCan you try?:

AddMonths(DateField, YearsField * 12)

[jagan]

Hi,

Try like this

LOAD

*,

AddYears(DateFieldName, YearsFieldName) AS NewDate

FROM DataSource;

Regards,

Jagan.

[#5]

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