Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
You can use function AddYears:
AddYears(YourDateField, NumOfYears)
Hi Tumelo, cCan you try?:
AddMonths(DateField, YearsField * 12)
Hi,
Try like this
LOAD
*,
AddYears(DateFieldName, YearsFieldName) AS NewDate
FROM DataSource;
Regards,
Jagan.
Hi All. Thanks a lot for replies, very helpful indeed. All Answers are correct. Pitty we can only mark one... 🙂