Lookup of dates › Forums › SPJS-Lookup › Lookup of dates This topic contains 5 replies, has 2 voices, and was last updated by Alexander Bautz 2 years ago. Author Posts October 7, 2015 at 23:00 #8657 lzuhuoParticipant Hi Alex, How can I set my lookup field in date format? It appears like “2015-10-07 00:00:00”, I’d like to be in “dd/mm/yyyy” format, but in order of dates. October 13, 2015 at 23:03 #8750 Alexander BautzKeymaster Hi, Sorry for the delay – can you give me some more information? – is it a Lookup column, or a vLookup column in DFFS you are referring to? Alexander November 25, 2015 at 21:08 #9403 lzuhuoParticipant Lookup column November 27, 2015 at 08:01 #9412 Alexander BautzKeymaster I see. Unfortunately this is the way the value is returned by the query. Your best option would be to add a calculated column with a formula returning your preferred date format – using this new column in your “spjs-lookup” column. Alexander November 30, 2015 at 14:02 #9427 lzuhuoParticipant Sure, but how can I filter this dates based on value of “today”? For example, dates which has values less than today, I would like to not show them November 30, 2015 at 22:36 #9442 Alexander BautzKeymaster Try using a CAML like this in the “filterObj”: <Where> <Geq> <FieldRef Name='EventDate' /> <Value Type='DateTime'> <Today /> </Value> </Geq> </Where> Change the “EventDate” to match your field. Alexander Author Posts You must be logged in to reply to this topic.