04-19-2017 02:57 PM - edited 04-19-2017 03:07 PM
I'd be extreemly grateful if someone could help with this. I have a column containing date and time information. From this I need to create a new column which shows the age based on the date (in days).
I also have a seperate dataset with a start date and end date (date and time) which I need to calculate the days between the start and end.
Solved! Go to Solution.
04-19-2017 03:25 PM
To calculate the age in Days:
Age = DATEDIFF(Table1[DateTimeColumn],TODAY(),DAY)
to calculate the days between the start and end.
DaysBetween = DATEDIFF(Table1[StarDate],Table1[EndDate],DAY)