Truncate date while using the Now() function

Question

I would like to know how to truncate a date when using the Now() function to avoid having hours seconds and minutes. Effectively I would would like to show only dd/mmm/yyyy.

My current code which is:

[Expected start date] = Now()

is returning in the field box:

13/04/2014 22:24:10

When i wish it would only return

13/04/2014

I imagine this may be simple for most but I am a beginner.

Does `[Expected start date] = Date()` give you what you want? — HansUp, Apr 13 '14 at 20:54
Exactly what i was looking for. Similar to the today's date function in Excel! grazie Hans — Marchese Il Chihuahua, Apr 14 '14 at 18:40

score 1 · Accepted Answer · answered Apr 13 '14 at 20:52

1

How about using Format. You really don't want to set the Expected start date field to a date, but instead a string.

Format(Now(),"dd/mm/yyyy")

answered Apr 13 '14 at 20:52

attila

2,219
1
11
15

Truncate date while using the Now() function

1 Answers1