Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Thanks a lot!! Sorry for the dumb question, didn't notice it.
No Worries. Learning is good 😄