Date function

[mario-sarkis]

hey all

i have a field looks like this :

example

6/1/2015 10:00:00AM

in need to show the data when this field is greater than today

hope you can help

‌

[deepakqlikview_123]

If(Date(Yourfield,'DD/MM/YYYY')>Date(Today),Date(Youfield,'DD/MM/YYYY'))

[Anonymous]

Just editing?

=If(Date(Yourfield,'DD/MM/YYYY')>Date(Today,'DD/MM/YYYY'),Date(Yourfield,'DD/MM/YYYY'))

[jonathandienst]

If this is a text field (it will be left aligned in a list box), then the correct approach is to convert this field to a proper date/time field during the load:

     LOAD

          ...

          TimeStamp#(dateField, 'd/M/yyyy hh:mm:ssTT') As dateField

          ...

Now you can do simple compare:

     If(dateField > today(), ....)

     or

     If(floor(dateField) > today(), ...)

     (depending on your requirements)

[tamilarasu · Accepted solution]

Hi Mario,

Try,

=If(Date(Date#(YourFieldName,'DD/MM/YYYY hh:mm:ss tt'),'DD/MM/YYYY')> Date(Today(),'DD/MM/YYYY'),YourFieldName)

Or

=If(Date(Left(YourFieldName,8),'DD/MM/YYYY')> Date(Today(),'DD/MM/YYYY'),YourFieldName)