DateTime Calculation 2

[PaulNewns]

I am trying to get the number of months between two date in a select statement with
'22/06/2005' - edat AS Period

but it returns the only the number of days and i have tried vaious things but seem only get errors. I have also tried UNITS Months but this returns a binary that i can't read. Can anyone help please.

 

[vpshriyan]

Assuming you have set date format to dmy4/

select substr(today,4,2) - substr(edat,4,2) ...
would give a rough calculation

 

[vpshriyan]

or you may use month() as
month(today) - month(edat)