Cannot format a date in Query- returns a blank

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

Guest

In Access 2003 i want format a date field to "mmm"", = Jan or Feb. However
the format function return a "blank field"
 
You didn't post what you tried. Assuming that you tried the following

Field: TheMonth: Format([TableName].[FieldName], "mmm")

And that did not work, then I might try checking your references to see if
any are marked as missing.


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Many thanks John,

I did exactly as you typed, also did check for missing references, but
nothing showed up! I also tried to convert a data base that is working fine
in Acc 2000, but it still is not working correctlty! Please truy and help,
thanks in advance.

John Spencer said:
You didn't post what you tried. Assuming that you tried the following

Field: TheMonth: Format([TableName].[FieldName], "mmm")

And that did not work, then I might try checking your references to see if
any are marked as missing.


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

werner said:
In Access 2003 i want format a date field to "mmm"", = Jan or Feb. However
the format function return a "blank field"
Click to expand...
Click to expand...
 
Hi -

As an experiment, try this from the debug (immediate) window and let us know
what it returns:

'today's date = 29-January-2007

? format(date(), "mmmm")
January

Does it return "January"? If not, you've got a reference problem.

Bob
Many thanks John,

I did exactly as you typed, also did check for missing references, but
nothing showed up! I also tried to convert a data base that is working fine
in Acc 2000, but it still is not working correctlty! Please truy and help,
thanks in advance.
You didn't post what you tried. Assuming that you tried the following
Click to expand...
[quoted text clipped - 5 lines]
Click to expand...
 
Bob,
"January" was indeed returned. The problem is now solved, initially the
database showed the following error when converted "msowc.dll" reference
missing. I was never saw this message and started to work - well long story
cut short, I deleted the tick mark now and it worked. (I'll never work on a
opened database again!!!)

Many thanks
Werner

raskew via AccessMonster.com said:
Hi -

As an experiment, try this from the debug (immediate) window and let us know
what it returns:

'today's date = 29-January-2007

? format(date(), "mmmm")
January

Does it return "January"? If not, you've got a reference problem.

Bob
Many thanks John,

I did exactly as you typed, also did check for missing references, but
nothing showed up! I also tried to convert a data base that is working fine
in Acc 2000, but it still is not working correctlty! Please truy and help,
thanks in advance.
You didn't post what you tried. Assuming that you tried the following
Click to expand...
[quoted text clipped - 5 lines]
In Access 2003 i want format a date field to "mmm"", = Jan or Feb. However
the format function return a "blank field"
Click to expand...
Click to expand...
Click to expand...
 
Back
Top