So the basic formula (1 option) would be: Using fromTimestamp(toNumber(“”)) returns a blank value in date format. Both of these outcomes need to be in a date format. Okay so, the reason the formula didn’t work in the first instance is because the IF statement needs 2 outcomes (value if true, value if false). I usually build my If formulas in stages, but I can't resolve the first if.įound it! (After all this work I ended up archiving this database and doing something completely different!)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |