Submitted by jan_rifkinson on 2012/06/03 14:31
Currently DateDone field is expressed in mm/dd/yyyy hh:mm::ss AM > PM
I wanted to change this to dd/mm/yyyy so 
in options I inserted <format>mm/dd/yyyy</format>
but it's not working. 
What am I doing wrong?

Comments

I think that you just didn't write it properly. It should be <format>dd/mm/yyyy</format>.
Put that in the "options" section of the field properties dialog, for that field.
 
--------------------------------------------------------------------------------
Windows XP Home Edition, Service pack 3
Dell Vostro 1500, Ram:3gb, CPU: Intel Core2Duo T7500 2.2ghz

jan_rifkinson

2012/06/05 17:23

Permalink

Hmmm. Thanks, Armando. 
Didn't realize I had to use european date format
when system date is set to 06/05/12 

Armando

2012/06/05 18:14

Permalink

If you solved it, that's what's important !
 
--------------------------------------------------------------------------------
Windows XP Home Edition, Service pack 3
Dell Vostro 1500, Ram:3gb, CPU: Intel Core2Duo T7500 2.2ghz

Tom

2012/06/06 16:21

Permalink

[quote=jan_rifkinson]
Hmmm. Thanks, Armando. 
Didn't realize I had to use european date format
when system date is set to 06/05/12 
[/quote]
 
I think Armando may have misunderstood (?)
 
My setup is a little different I think:
 
My dateDone field has Default Value of
=int(now)
and I added
<format>mm/dd/yyyy</format>
in the "Options" section of field properties
 
My yes/no Done field has this in equations:
A:DateDone=int(now())|E:DateDone=
 
Oddly enough, when I try here
it uses my system date which is yyyy/mm/dd
 
 
IIUC your field is ignoring the system date Jan?
 
_______________________________________________________
Win.7 64bit  ~  IQ 0.9.25W10 portable

Armando

2012/06/06 16:59

Permalink

Hi Tom,
 
Yes, I might have misunderstood. However Jan says this :
 
[quote]
I wanted to change this to dd/mm/yyyy so 
in options I inserted <format>mm/dd/yyyy</format>
[/quote]
 
...which seems slightly contradictory. Hence my suggestion.
 
You say :
[quote]
Oddly enough, when I try here
it uses my system date which is yyyy/mm/dd
[/quote]
 
What do you mean ? In "Edit" mode the date appearing should be the system date
However, while NOT in edit mode, it should be displayed as set in the "options" section (if you did set a format option there).
I haven't tested all cases, but this is what has happened (and seems to be happening) here.
 
--------------------------------------------------------------------------------
Windows XP Home Edition, Service pack 3
Dell Vostro 1500, Ram:3gb, CPU: Intel Core2Duo T7500 2.2ghz

Tom

2012/06/06 18:39

Permalink

[quote=Armando]
You say :
[quote]
Oddly enough, when I try here
it uses my system date which is yyyy/mm/dd
[/quote]
 
What do you mean ? In "Edit" mode the date appearing should be the system date
However, while NOT in edit mode, it should be displayed as set in the "options" section (if you did set a format option there).
I haven't tested all cases, but this is what has happened (and seems to be happening) here.[/quote]
 You're correct Armando - I was looking in the Properties pane which shows the system date...
 
@Jan,
that means the mm/dd/yyyy format is working here
 
_______________________________________________________
Win.7 64bit  ~  IQ 0.9.25W10 portable