fornat date fields coming from a linked oracle table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do i format a date that is coming from a linked oracle table such that
it recognizes that years between 30-99 are 19xx. When we display these date
fields now they are coming out as 2080 when they should be 1980. I know if
you enter the date in access directlly it will automatically apply it's own
logic that display the date correctly.
 
How about some variation of:
If > 20 Then
Num + 1900
Else
Num + 2000
End If

How do i format a date that is coming from a linked oracle table such that
it recognizes that years between 30-99 are 19xx. When we display these date
fields now they are coming out as 2080 when they should be 1980. I know if
you enter the date in access directlly it will automatically apply it's own
logic that display the date correctly.
Click to expand...
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
 
Back
Top