May 25, 2012 at 9:27 am
I am trying to get just the DATE part of now. In a report expression, how do I eliminate all the HH:MM:SS stuff and just get the mm/dd/yyyy 00:00:00
May 25, 2012 at 10:11 am
Never mind, I finally got it.
Instead of using Now in my expressions, I created a hidden parm called pToday. Its value is :
CDate(datepart("m",now) + "/" + datepart("d",now) + "/" + datepart("yyyy",now))
May 25, 2012 at 4:45 pm
huh:? if it is a textbox., format the properties of the texbox to date and pick the format you want. do that by right clicking the textbox. or FormatDateTime(Now, DateFormat.ShortDate)
June 2, 2012 at 8:50 pm
Or in case your problem has not got resolved yet, here is another option that you can try...
=Format(Now(),"MM/dd/yyyy")
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply