Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How to recode date by M code when user data entry mistake ?

Hi All   My CSV file have data entry mistake , the date should 04/01/2017 but user enter wrongly . Can some one share how to recode the date ? My PBI file :- https://www.dropbox.com/...
Need Help
v-jingzhang's avatar
v-jingzhang
Community Support
5 years ago

Hi Anonymous , please refer to the image below.

Best regards,

Jing

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Jing

    That is good suggestion. in case one of the invoice sales staff enter the wrong date , and this date we have 20 invoice , how to change the date link to invoice numner ?

    Paul 

    • v-jingzhang's avatar
      v-jingzhang
      Community Support
      5 years ago

      Anonymous With this replace values function, it will replace all the same wrong date in the selected date column with the correct one no matter what invoices they are linked to. 

      Jing

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi Sir

        Assume today on 04/11/2020 , there are 100 invoice , and one of the invoice date error entry enter as 11/04/2020 , and during 11/04/2020 which is april  , also have 1-- invoice , will all also change to 04/11/2020 ?

        Paul