Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Great article, need more like this, however... Expand / Collapse
Author
Message
Posted Saturday, March 06, 2010 8:13 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 06, 2013 2:55 PM
Points: 3, Visits: 39
I went through and tried all the formulas. The one for the last day of the month works well except if the previous month was February. But I also ran into another weird issue. The following formula did not work for me and I can't figure out why:

=Format(Today,"M")

Returned:

March 05

From everything I've researched it should return the month digit. Does anyone have any ideas on why I get todays date instead with month and day.
Post #878156
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse