topic Re: Date# does not recognize the correct date in App Development

Date# does not recognize the correct date

Defo — Tue, 02 Aug 2022 09:05:51 GMT

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

Re: Date# does not recognize the correct date

MayilVahanan — Tue, 02 Aug 2022 09:33:31 GMT

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.

Re: Date# does not recognize the correct date

Defo — Tue, 02 Aug 2022 09:44:02 GMT

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

Re: Date# does not recognize the correct date

MayilVahanan — Tue, 02 Aug 2022 09:45:59 GMT

No Worries. Learning is good 😄