CONVERT DATETIME FIELD TO DATE ONLY

hello @koboldinst ,

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.

• Quick Date Filter in a GI

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!

@koboldinst Can you please try this formula?

=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.

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)