Yogi Anand, D.Eng, P.E. Google Spreadsheet Post #783 Sep 28, 2012 www.energyefficientbuild.com.
user unicom said: (http://productforums.google.com/forum/?zx=d088tq41gvii#!category-topic/docs/spreadsheets/1Or85dznYHA
auto correcting a date format
Could anyone point me toward a help page or help me set up some kind of formula where by when customers insert a date into a form it can be automatically changed to produce one date format only. Some choose for example dd.mm.yy or dd.m.yy or dd.mm.yyyy I have clear instructions as to how dates should be entered but invariably they are ignored and the various forms of date entry are accepted by the form and I end up manually correcting them. I would like to either restrict entry to dd\mm\yyyy or create some kind of formula that automatically corrects it.
Any suggestions would be welcome.
---------------------------------------------------------------------------------------------
I have assumed here that you had the column receiving the dates formatted as plain Text and the entries in the Form are acceptable date entries -- if the Form entries are not acceptable dates, then the problem would be a little more complex.
user unicom said: (http://productforums.google.com/forum/?zx=d088tq41gvii#!category-topic/docs/spreadsheets/1Or85dznYHA
auto correcting a date format
Could anyone point me toward a help page or help me set up some kind of formula where by when customers insert a date into a form it can be automatically changed to produce one date format only. Some choose for example dd.mm.yy or dd.m.yy or dd.mm.yyyy I have clear instructions as to how dates should be entered but invariably they are ignored and the various forms of date entry are accepted by the form and I end up manually correcting them. I would like to either restrict entry to dd\mm\yyyy or create some kind of formula that automatically corrects it.
Any suggestions would be welcome.
---------------------------------------------------------------------------------------------
I have assumed here that you had the column receiving the dates formatted as plain Text and the entries in the Form are acceptable date entries -- if the Form entries are not acceptable dates, then the problem would be a little more complex.
No comments:
Post a Comment