I have the formula
=RANDBETWEEN(DATE(1930,1,3),NOW()-1) in a cell to give me a random date. I have the format of the cell set to a date so the random number looks like a date. For example
38562 looks like
7/29/2005. So far so good, however when I use the value in another formula is shows
=CONCATENATE("INSERT INTO random.#persons(birth_date) VALUES ('",L1,"');") fails as the birth_date isn't in a date format. How can I convert an number into a date?