I have searched for literally five hours and cannot find such a simple thing.
I am creating an SQL database and want to put in a column formula for both a date and a time field (both defined datetime).
I need one to be the date in yyyy/mm/dd format and one to be mm/dd/yyyy hh/mm format.
I've tried putting in the above (I know that minutes are nn) "yyyy/mm/dd" & "mm/dd/yyyy hh/nn" respectively but it gives the error "Error validating the formula for column 'TDate'".
I feel like this is the most ridiculous qustion I've ever asked.