Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Date Format Issue

Discussion in 'Information Technology' started by epete367@optonline.net, Oct 27, 2005.

Tags:
  1. epete367@optonline.net

    epete367@optonline.net
    Expand Collapse
    Guest

    I have a form where a user checks a check box for months desired. The
    check boxes are named January...December. I need these boxes to return
    the first day of that month for future shipping. For example November
    should return November 1, 2005 while February should return February 1,
    2006.
    I thought I could use something like:
    If Me.January.Value = True Then
    [Forms]![frmShippingCalendar][txtJanuary].Value =
    But from there I am not sure what date function/format to use.
    Ultimately, this will be used to populate a shipping calendar report.
     
  2. Loading...


  3. Brendan Reynolds

    Brendan Reynolds
    Expand Collapse
    Guest

    If Me.January.Value = True Then
    Forms!frmShippingCalendar!txtJanuary.Value = DateSerial(Year(Date(), 1,
    1)

    The DateSerial function takes three integer numbers, for the year, month,
    and day, in that order. See 'DateSerial Function' in the help file for
    details.

    --
    Brendan Reynolds


    <epete367@optonline.net> wrote in message
    news:1130352703.909485.155970@g47g2000cwa.googlegroups.com...
    >I have a form where a user checks a check box for months desired. The
    > check boxes are named January...December. I need these boxes to return
    > the first day of that month for future shipping. For example November
    > should return November 1, 2005 while February should return February 1,
    > 2006.
    > I thought I could use something like:
    > If Me.January.Value = True Then
    > [Forms]![frmShippingCalendar][txtJanuary].Value =
    > But from there I am not sure what date function/format to use.
    > Ultimately, this will be used to populate a shipping calendar report.
    >
     

Share This Page