topic Re: Date format in if condition in App Development

Date format in if condition

rahulramanm — Tue, 02 Jul 2019 14:15:58 GMT

Hi,

I am trying to filter data based on date. I am using if statement here.

Code:

if(day(max(DATEFIELD))>'25','25/'&month(max(DATEFIELD))&'/'&year(max(DATEFIELD)),max(DATEFIELD))

The else part should return date in 'DD/MM/YYYY' format, but it's returning the date's floor value. I need the code to return the date in 'DD/MM/YYYY' format.

Please help.

Re: Date format in if condition

Lauri — Tue, 02 Jul 2019 14:25:12 GMT

Try formatting the else part:

date(max(DATEFIELD), 'DD/MM/YYYY')

Re: Date format in if condition

rahulramanm — Wed, 03 Jul 2019 03:59:16 GMT

Already tried this, not working. 😞

Re: Date format in if condition

Lauri — Wed, 03 Jul 2019 16:35:24 GMT

Maybe the second part of your If statement needs to be explicitly a date (with makedate) instead of text:

date(if(day(max(DATEFIELD))>'25', makedate(year(max(DATEFIELD)), month(max(DATEFIELD)), 25), max(DATEFIELD)), 'MM/DD/YYYY')

Re: Date format in if condition

sasiparupudi1 — Wed, 03 Jul 2019 19:55:30 GMT

may be try

if(day(max(DATEFIELD))>'25',

MakeDate(year(max(DATEFIELD)),month(max(DATEFIELD)),25),

,max(DATEFIELD))

Re: Date format in if condition

rahulramanm — Thu, 04 Jul 2019 05:23:03 GMT

Thanks Sasi,

Just a change in code : Makedate has to be formatted to 'DD/MM/YYYY' in my case.

Re: Date format in if condition

rahulramanm — Thu, 04 Jul 2019 05:24:12 GMT

Thanks Laurischarf,

Just a change in code : Makedate has to be formatted to 'DD/MM/YYYY' in my case.