Date format help

[Guest]

From the input of a date in short format, say 5/1/2005, I want to output the
name of the month. For example, May. I made a small table with the names of
the months and the corresponding numbers, and I'm trying to use DLookup, but
I'm having trouble figuring out what to do with the months represented by two
digits. Is there an easy function that will do this?

I tried to work with this:

Left$(DLookUp("[Month_Name]","[tbl_Months_of_the_Year]","[Month_Number]=string(1,left$([txtDate],1))"),3) & (Right$(txtDate],2))

where the txtDate is in the mm/dd/yyyy format

Will this work when the month has two digits?

 

[Guest]

You don't need to use a DLookUp to get the month. In the control source of
the box you want to display the month in put this
=Format(txtDate,"mmmm")

 

[Guest]

Thanks Dennis, but I don't want to display the month in a box. I'm actually
going to concatenate the month name from the first part of the date that has
been input into a form, transformed into a three character name from the
mm/dd/yyyy format, with the two last digits of the year and another part of
an alphabetic term from another source. I can't figure how to use your
suggestion for that.

You don't need to use a DLookUp to get the month. In the control source of
the box you want to display the month in put this
=Format(txtDate,"mmmm")

From the input of a date in short format, say 5/1/2005, I want to output the
name of the month. For example, May. I made a small table with the names of
the months and the corresponding numbers, and I'm trying to use DLookup, but
I'm having trouble figuring out what to do with the months represented by two
digits. Is there an easy function that will do this?

I tried to work with this:

Left$(DLookUp("[Month_Name]","[tbl_Months_of_the_Year]","[Month_Number]=string(1,left$([txtDate],1))"),3) & (Right$(txtDate],2))

where the txtDate is in the mm/dd/yyyy format

Will this work when the month has two digits?

 

[Guest]

Format(txtDate,"mmm") & Right("0" & CStr(Year(txtDate)-2000),2) & "Other"

Thanks Dennis, but I don't want to display the month in a box. I'm actually
going to concatenate the month name from the first part of the date that has
been input into a form, transformed into a three character name from the
mm/dd/yyyy format, with the two last digits of the year and another part of
an alphabetic term from another source. I can't figure how to use your
suggestion for that.

You don't need to use a DLookUp to get the month. In the control source of
the box you want to display the month in put this
=Format(txtDate,"mmmm")

From the input of a date in short format, say 5/1/2005, I want to output the
name of the month. For example, May. I made a small table with the names of
the months and the corresponding numbers, and I'm trying to use DLookup, but
I'm having trouble figuring out what to do with the months represented by two
digits. Is there an easy function that will do this?

I tried to work with this:

Left$(DLookUp("[Month_Name]","[tbl_Months_of_the_Year]","[Month_Number]=string(1,left$([txtDate],1))"),3) & (Right$(txtDate],2))

where the txtDate is in the mm/dd/yyyy format

Will this work when the month has two digits?

 

[Guest]

OK Dennis, it works; but could you please try to give me a little explanation
of it.

Format(txtDate,"mmm") & Right("0" & CStr(Year(txtDate)-2000),2) & "Other"

Thanks Dennis, but I don't want to display the month in a box. I'm actually
going to concatenate the month name from the first part of the date that has
been input into a form, transformed into a three character name from the
mm/dd/yyyy format, with the two last digits of the year and another part of
an alphabetic term from another source. I can't figure how to use your
suggestion for that.

You don't need to use a DLookUp to get the month. In the control source of
the box you want to display the month in put this
=Format(txtDate,"mmmm")

:

From the input of a date in short format, say 5/1/2005, I want to output the
name of the month. For example, May. I made a small table with the names of
the months and the corresponding numbers, and I'm trying to use DLookup, but
I'm having trouble figuring out what to do with the months represented by two
digits. Is there an easy function that will do this?

I tried to work with this:

Left$(DLookUp("[Month_Name]","[tbl_Months_of_the_Year]","[Month_Number]=string(1,left$([txtDate],1))"),3) & (Right$(txtDate],2))

where the txtDate is in the mm/dd/yyyy format

Will this work when the month has two digits?

 

[Guest]

I figured it out. Thanks.

OK Dennis, it works; but could you please try to give me a little explanation
of it.

Format(txtDate,"mmm") & Right("0" & CStr(Year(txtDate)-2000),2) & "Other"

Thanks Dennis, but I don't want to display the month in a box. I'm actually
going to concatenate the month name from the first part of the date that has
been input into a form, transformed into a three character name from the
mm/dd/yyyy format, with the two last digits of the year and another part of
an alphabetic term from another source. I can't figure how to use your
suggestion for that.

:

You don't need to use a DLookUp to get the month. In the control source of
the box you want to display the month in put this
=Format(txtDate,"mmmm")

:

From the input of a date in short format, say 5/1/2005, I want to output the
name of the month. For example, May. I made a small table with the names of
the months and the corresponding numbers, and I'm trying to use DLookup, but
I'm having trouble figuring out what to do with the months represented by two
digits. Is there an easy function that will do this?

I tried to work with this:

Left$(DLookUp("[Month_Name]","[tbl_Months_of_the_Year]","[Month_Number]=string(1,left$([txtDate],1))"),3) & (Right$(txtDate],2))

where the txtDate is in the mm/dd/yyyy format

Will this work when the month has two digits?