Date Variable

[Phil Davis]

Hi Jeff,

I know you found an answer, but here's another way that works:

   put tMonth,tDay,tYear into tQueryDate
   replace comma with slash in tQueryDate

And there are probably 14 other ways to do it besides this one.

Have fun -
Phil Davis


Jeff Honken wrote:
> I've been trying to tie in three variables to make a date.  I've tried
> 
> put  '" & tDay & "' / '" & tMonth & "' / '" & tYear & "' into QueryDate
> put (tMonth)/(tDay)/(tYear) into QueryDate
> 
> The below example does work but I need the / in the date.  It gives me
> 02142007
> 
> put tYear & tMonth & tDay into QueryDate
> 
> 
> How do I put a / in the above so I would get a date such as 02/14/2007
> Every combination I can think of seems to error.  Any ideas would be
> greatly appreciated.  Jeff