Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI All,
To display the data's by month wise for example Jan Feb Mar i have data only for month Feb month and the field with Date and time when i select Feb month i should display the data's for the Feb month. Can any one help on this.
Thanks & Regards,
sivakumar
Hi
Try below in load script.
Load Field1,
Field2,
DateTimeField,
Date(Floor(DateTimeField)) as Date,
Month(DateTimeField) as Month
from table
Now use month in your front end to filter
Regards
ASHFAQ
Hi sivakumar,
From your Date&Time Field work like this,
If it is text format,
Load
month(floor(date(date#(YourDate&TimeField,'DD-MM-YYYY hh:mm:ss') ,'DD-MM-YYYY'))) as Month
From source;