I notice that the funcion Year(current date) works in different way in dataease 8. (or post 6.52) I mean if I try to run this DQL

message year (current date) window.

In dataease 8 the results is 2014

In dataease 6.52 is 14

The settings inside control panel is unchanged (short date format dd/mm/yyyy) in any case.

I've just migrated in windows 8 and this is a great problem for us because we have many statistical forms based on the current year.

Marco,

Easy way around this :

message lastc (current date,2) window.

Using lastc as above instead of year will pull the last 2 characters from the date field.

Incidently I can't get year(field) ina  DQL to work AT ALL in datease 7.2 and oly partly in 6.52 lol:

6.52 shows 10 for 2010 (good) but 8 for 2008 lol. and

7.1

message year(datefield) window -- works

but

list records

   year(datefield) -- doesn't work, shows ** instead of 13 or 14 !