Date ;;

[#1]

Thanks

Madhu

[gautik92 · Accepted solution]

if(date(vMakeToday)<vToday,Date(vToday,'MM-DD-YYYY'),Date(vMakeToday,'MM-DD-YYYY'))

[settu_periasamy]

Try,

=Date(if(vMakeToday<vToday,vToday),'MM-DD-YYYY')

[simospa]

Hi Josna,

first of all, next time write your request in the textarea and not in an attachment: it will help other users with your same problem in the future.

Try to use the Date function to convert che numeric date in a date format: =Date(yourdatefield,'MM-DD-YYYY')

In your example:

= 'Date as of: ' & Date(if(vMakeToday<vToday,vToday),'MM-DD-YYYY')

or

=if(vMakeToday<vToday,'Date as of: ' & Date(vToday,'MM-DD-YYYY'))

Let us know

S.

[gautik92]

=Date(if(vMakeToday<vToday,vToday),'MM-DD-YYYY')

[avinashelite]

try like this :

if(vMakeToday<vToday,vToday,Date(vMakeToday,'MM-DD-YYYY'))

[#7]

Hi Simone

Ok Fine thank you very much for giving suggestion.

Josna.

[avinashelite]

if you have got the answer, please mark the correct answer and close this thread