Joined: 25 Aug 2009
Location: United States
Online Status: Offline
Posts: 166
Topic: Help:converting Date Field Posted: 19 Nov 2009 at 8:45am
Hello Folks,
I have a field called BeginDate which has data as 12/5/2008 12:00:00AM. I need to create a formula where it will get rid of "time part" i.e 12:00:00AM. I have tried using round but its not working. Any ideas on this.
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 19 Nov 2009 at 9:31am
If you really need to remove the time then use
date(field)
Likely you can just alter the way it looks though. Right click on it and select the format field and the Date Time Tab and pick the way you want ot to look (without any time value)
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
