Date Question

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

Guest

I have written the following:

[Form].[frmTranser].[ReceivedDate] = [Form].[frmInventory].[ReceivedDate]

It does not copy the date format (mm/dd/yyyy) with an input value of
00/00/0000;0;"_" properly.

Is there something I am doing wrong? I even tried the
Format$([ReceivedDate], "mm/dd/yyyy") and that did not work.

Any help would be greatly appreciated. Thank you in advance for any responses.

Rick
 
Rick:

Set the format of ReceivedDate on your form frmTranser to the format you want.

John H W
 
John:

I have all the fields showing a date format of mm/dd/yyyy and an input of
00/00/0000;0;"_". It still does not copy over.

Rick

John H W said:
Rick:

Set the format of ReceivedDate on your form frmTranser to the format you want.

John H W

Rick_C said:
I have written the following:

[Form].[frmTranser].[ReceivedDate] = [Form].[frmInventory].[ReceivedDate]

It does not copy the date format (mm/dd/yyyy) with an input value of
00/00/0000;0;"_" properly.

Is there something I am doing wrong? I even tried the
Format$([ReceivedDate], "mm/dd/yyyy") and that did not work.

Any help would be greatly appreciated. Thank you in advance for any responses.

Rick
Click to expand...
Click to expand...
 
Rick:

I just set up a test form with only two date fields (fmDateOne and
fmDateTwo). Both were formatted to Short Date (no input value). In the
first date field, in the On_Exit event code, I put fmDateTwo = fmDateOne -
this works as I understand your problem.

I'm leaving and won't be back to work until Monday, so I hope this points
you in the right direction.

John H W

Rick_C said:
John:

I have all the fields showing a date format of mm/dd/yyyy and an input of
00/00/0000;0;"_". It still does not copy over.

Rick

John H W said:
Rick:

Set the format of ReceivedDate on your form frmTranser to the format you want.

John H W

Rick_C said:
I have written the following:

[Form].[frmTranser].[ReceivedDate] = [Form].[frmInventory].[ReceivedDate]

It does not copy the date format (mm/dd/yyyy) with an input value of
00/00/0000;0;"_" properly.

Is there something I am doing wrong? I even tried the
Format$([ReceivedDate], "mm/dd/yyyy") and that did not work.

Any help would be greatly appreciated. Thank you in advance for any responses.

Rick
Click to expand...
Click to expand...
Click to expand...
 
Back
Top