Forum Discussion

SamSam's avatar
SamSam
Qrew Member
9 years ago

How can one convert a ""Date/Time"" value to a ""Date Only"" value?

'5/6/2015 7:00 AM'  to '5/6/2015'

12 Replies

  • Worked like a charm!  I had done that, but had the wrong field type.  I had Date/Time instead.  So, next question would be, how can i populate a field with the time a field is changed.  Currently, I have this in the formula url, but it still prints the date AND time.  Is there something I can do to make it just print the time?

    & "&_fid_20=" & URLEncode (Now())
  • try this, assuming that fid 20 is a time of day field (or I guess a text field) .

    & "&_fid_20=" & URLEncode (ToTimeOfday(Now()))