LEFT Function

[Zac]

Why doesn't the following pull the 01 from the date?

=LEFT(C8.2)

When C8 had 01/07/2004.

It works for 1234 and pulls 12.

Is there any way I can do it?

 

[shades]

I think it is pulling the first two of the serial number for the date (37628), not the date itself.

 

[Seti]

Is the date a date or text field. If it is a date field, try MONTH(C8).

 

[Joe4]

Because dates are stored as numeric values (the number of days since 1/1/1900).

Try:
=MONTH(C8)

 

[BuddieB]

Try this:

=LEFT(TEXT(C11,"mm/dd/yyyy"),2)

 

[just_jon]

Because that is just a format; dates are numbers like 37994.6443376157 where the integer portion = days and the decimal portion hours/minutes/seconds. etc -- so, to get the month use--

=MONTH(C8)

format as desired.

 

[BuddieB]

yes you can use that left function within an if statement.

it would look something like:

if (left(text(C1,"mm/dd/yyyy"),2)="01",DO SOMETHING,DO SOMETHING ELSE)

you actually dont even need the "/dd/yyyy" part if you dont want it.

 

[NateO]

See your duplicate thread ('BuddyB').

Please don't create duplicates! Simply respond to this thread.

Edit: From the BuddyB thread:

=IF(ISNUMBER(C11),IF(MONTH(C11)=1,"yep","nope"),"nope")

IsNumber() is simply defensive.

I'll delete the 'BuddyB' thread at this point.

 

[Zac]

Thanks everyone. I'll check things out this morning and see what happens.
This task should be a lot easier to resolve than it has been so far.