cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

DATEADD Function Not Working

Hi,

 

I am having all sorts of troubles for something that should be easy.

 

I have a date column, and i simply want to add the number of months shown in another column to the original date.

 

The Date is in a table called X_Services, the Additional months i want to add is from a related table called "Promo_Months".

 

In the table X_Services i have the promo_months value show via the related function. Not sure if this is what's causing the issue.

 

I am using the DATEADD function to no avail, can anyone shed some light on how to successfully achieve this.

 

I did this and got the result on one occassion, but mysteriously only where the additional months value of 2 was shown .. the rest didn't show?

Date.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User I
Super User I

Re: DATEADD Function Not Working

@ToddMate  hi can you share some data (not in pic format, text format) from both tables

 

and also provide the calculations you are using.

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
Highlighted
Super User I
Super User I

Re: DATEADD Function Not Working

@ToddMate  hi can you share some data (not in pic format, text format) from both tables

 

and also provide the calculations you are using.

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Highlighted
Helper II
Helper II

Re: DATEADD Function Not Working

Hi @vanessafvg 

 

I've sorted it out, thanks for your offer of assistance though.

Super User I
Super User I

Re: DATEADD Function Not Working

@ToddMate  great what was the issue?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors