You’re offline. This is a read only version of the page.
Announcements
Hi team, I would like to ask about a function call "DataValue" from Excel in PowerApps, my objective is build a numerical ID with this.
I tried with "Value" function.
Hi @Anonymous :
Firstly, let me explain the principle of the DataValue function in Excel.
The DATEVALUE function converts a date that is stored as text to a serial number that Excel recognizes as a date. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,447 days after January 1, 1900.
Secondly, in PowerApps we usually use the Value function to convert characters to numbers. In theory, it has no ability to deal with date characters.
Finally, I have an alternative for your reference:
Considering the characteristics of DataValue function in excel, I suggest you try this function in power apps:
Share
Report
All responses (
Answers (
DateDiff(Date(1900,1,1),Today(),Days)+1I think this link will help you a lot:
DATEVALUE function:
https://support.office.com/en-us/article/datevalue-function-df8b07d4-7761-4a93-bc33-b7471bbff252
DateAdd, DateDiff, and TimeZoneOffset functions in Power Apps:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-dateadd-datediff
Best Regards,
Bof
796
