as per the requirement,
I have to convert user texts into DB date format
Required format: YYYY/MM/DD
expected date inputs:
Discussion posts and replies are publicly visible
Convert text dates by using the DATEVALUE functionEnter =DATEVALUE(Click the cell that contains the text-formatted date that you want to convert.Enter )Press ENTER and the DATEVALUE function returns the serial number of the date that is represented by the text date.
© 2023 Appian. All rights reserved.