Forum Discussion

IfaZ_1's avatar
IfaZ_1
Icon for Helper I rankHelper I
3 years ago

How to Replace Date

Hello everyone,    I want to replace the Last assessment Date (00-01-00) to Audit_Issues_2.Assessment Date the outcome should be in FTY_ASSESSMENT_DATE.  I have tried using power query with this c...
Need Help
PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
3 years ago

Hi IfaZ_1 

 

The data in the Last Assessment column aren't dates so your code checking if it is equal to another date will always result in False which si what you are getting.  The result is Last Assesment Date

 

What data are you trying to store in the Last Assessment Date column?

 

00-01-00 isn't a date.

 

Regards

 

Phil

IfaZ_1's avatar
IfaZ_1
Icon for Helper I rankHelper I
3 years ago

Hi Phil,

Thank you so much for your reply.

I have changed Last Assessment Date, Audit Date and FTY_ASSESSMENT_DATE to Date format already. Still doesnt solve it.