Lookup of dates

Home › Forums › SPJS-Lookup › Lookup of dates

Viewing 5 reply threads
  • Author
    Posts
    • October 7, 2015 at 23:00 #8657
      lzuhuo
      Participant

        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 Bautz
        Keymaster

          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
          lzuhuo
          Participant

            Lookup column

          • November 27, 2015 at 08:01 #9412
            Alexander Bautz
            Keymaster

              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
              lzuhuo
              Participant

                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 Bautz
                Keymaster

                  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
              Viewing 5 reply threads
              • You must be logged in to reply to this topic.