title: How to stop Time data being appended to Today() (powerapps and excel)
body: <p>I am trying to use powerapps to create a submission form for users.</p>
  <p>The issue is that I have one field for submission date.<br />
  All I want is the short date added to the table column when the user clicks submit.</p>
  <p>What I get is the shortdate with</p>
  <p>YYYY-MM-DDTHH:MM:SS.SSOZ</p>
  <p><a href="https://i.stack.imgur.com/DvrzH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DvrzH.png" alt="Problem" /></a></p>
  <p>I have tried:</p>
  <p><code>Text(Today(), &quot;[%-en-US]YYYY-MM-DD&quot;)</code></p>
  <p><code>Text(Today(), DateTimeFormat.ShortDate)</code></p>
  <p><code>Left(Text(Today(), &quot;[%-en-US]YYYY-MM-DD&quot;),10)</code></p>
  <p><code>Left(Text(Today(), DateTimeFormat.ShortDate),10)</code></p>
  <p>I have tried setting the excel table field to &quot;Text&quot;</p>
  <p>I have tried setting it back to date and using just the short date without conversion.
  Is there any end to this madness?</p>
  <p>Thanks!</p>