[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 152
  • Last Modified:

MaskEdit box will not populate with date

The code below should I though populate the mask edit box but instead of giving the date 1/30/2008 it gives me nothing.  When I trace it the value of     dtmcompleted is 1/30/2008.  the mask is ##/##/####.

thank you

If IsDBNull(Dsmfg1.Tables("tblPAMfg").Rows(0).Item("dtmcompleted")) = False Then
                        If Dsmfg1.Tables("tblPAMfg").Rows(0).Item("dtmcompleted") <> "1/1/1900" Then
                            dtmcompleted.CtlText = Dsmfg1.Tables("tblPAMfg").Rows(0).Item("dtmcompleted")

                        End If
                    End If
0
running32
Asked:
running32
1 Solution
 
SanclerCommented:
Try changing the .PromptInclude property of dtmcompleted from True to False.

If that doesn't work, could you please say what is the datatype of Dsmfg1.Tables("tblPAMfg").Rows(0).Item("dtmcompleted")?

If (as seems possible) it is a DateTime, try adding .ToString - like this -

                            dtmcompleted.CtlText = Dsmfg1.Tables("tblPAMfg").Rows(0).Item("dtmcompleted").ToString

Roger
0
 
running32Author Commented:
That worked.  thanks
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now