I am creating a GI and need to pull for a Date, however the field i need to use is a DATETIME field. I feel like it should be easy to convert it to a DATE field only but it doesn’t seem to be. Any hints? I’ve tried every scenario that i can think of and google...I’ve added things to the Data Field, Schema Field, Style etc. i can do a LEFT(Start Date,11) but then when i try to add a condition that it pulls @Today, nothing will show. I am assuming it’s b/c of the timestamp attached to the Date.
Best answer by Naveen Boga
+19hello
I know Date formatting is tricky & I know I’ve seen similar questions asked before. Did you notice this post answered by Gabriel Michaud? Please keep reading beyond the “Best Answer” post because I think Brian McMillan posted the answer to your question above (removing time from a Date field to acheive a condition that recognizes a match and returns records with a certain filtered date), further down the thread.
I hope this helps you!
Laura
Hi,
You can use following parameters of Format function:
format('{0:MM/dd/yyyy}', [StartDate])
@Laura02 Thanks, I had already found that answer and tried it. If i put it into the Data field, it still returns the time.
@Yulias18 That did not work putting it into the Data field
Thanks though!
+19
=Concat(CStr(Month([CRActivity.StartDate])),'/' , CStr(Day( [CRActivity.StartDate])),'/',CStr(Year( [CRActivity.StartDate])))
Hi Naveen - Yes that works, I had already tried that but i need it to show just for today...and that GI data is then being brought into a master Velixo worksheet. So i need it to filter =today() somehow and that’s the part that’s not working. I can filter on the results screen but that won’t help me use the data for a Velixo report.
+19
Use this to get a datetime field to just date so it can compare it to today() or any other smalldate field
=DateAdd( [POReceipt.CreatedDateTime],'d',0)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
