Date# does not recognize the correct date

[Defo]

Hi everybody! I have a particular issue with the Date# function, which does not recognize correctly a date column that I have as a string (IsText true, but I don't have access to the soure data and I can not verify that).

The function works correctly only for January's days and num function gives slightly different results for each months.

Can you please help me out with this function? Maybe I'm using it in the wrong way.

thankss

[MayilVahanan · Accepted solution]

Hi

Try like below
num(date#(RegistrationDate, 'yyyy-MM-dd')) or num(date#(RegistrationDate, 'YYYY-MM-DD'))

for Month, "MM" need to be in upper case.
mm- indicates minute.

[Defo]

Thanks a lot!! Sorry for the dumb question, didn't notice it.

[MayilVahanan]

No Worries. Learning is good 😄