Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Help - Date formatting
0 views
Skip to first unread message
Prout®
Jul 15, 1998, 3:00:00 AM7/15/98
to
I have an application requiring to use a YYYY-MM-DD formats for all dates
entered and displayed. My bigest problem is that all dates between
1950-1999 display YY-MM-DD.
entered and displayed. My bigest problem is that all dates between
1950-1999 display YY-MM-DD.
What can I use to format the dates. If I need to use script, please provide
an example since I am not really good with script. The Format statement
should do the trick but how do I apply it (what event, etc..).
Prout
Mike Moller
Jul 16, 1998, 3:00:00 AM7/16/98
to Prout®
why use script?
in most situations its more effective in the GUI to use @function stuff
in most situations its more effective in the GUI to use @function stuff
break the date as entered into its components using @Day, @Month and
@Year use @Text to turn 'em into Text string and do some normal text
string manipulations to format it how you want it. use the Input
translation formula provison
0 new messages