date

[rathnam_qv]

Hi all,

explain how it will works

date(date#(Month,'MMM'),'MMM')as Monthes;

Thanks!!!!

Smiley

[er_mohit]

date(date#(Month,'MMM'),'MMM')as Monthes

because in your month field then date# tells you the format of Month i.e in Jan

and the date function gives tells you the format in which you want i.e also a 'MMM'

so if date# format corrects then date function also correct

so, it gives you right answer as expected

hope it helps you

[er_mohit]

see the attached file of date hope it helps you

[#4]

date(date#(Month,'MMM'),'MMM')as Monthes;

here date#() function tells the format of your datefield.

and date() function tells the in which format you want the datefield.

[er_mohit · Accepted solution]

if your problem resolved then mark it as either helpful or correct anwer so that it might be helpful for other developer