Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All Fairly new here..
Just wanting to find out how would i go about achieving the following:
I have a field named TIme , withing that is the following
01 Apr 2018 , 11:19:59 PM
01 Apr 2018 , 11:20:22 PM
01 Apr 2018 , 11:20:24PM
02 Apr 2018 , 11:19:59 PM
05 Apr 2018 , 11:19:59 PM
01 May2018 , 11:19:59 PM etc,etc
This holds 11 months Jan>Nov
I need to create seperate fields for each month to add them to straight table e.g:
Jan| Feb| Mar| Apr| ....
I do not require the times or date just months in order to align my data to the specific month, how would i go about achieving this?
Thanks
If your TIme field contains timestamps and not strings you can use the Month function directy: Month(TIme) as Month.
If that field contains string values you first need to convert the strings to timestamps: Month(timestamp#(TIme, 'DD MM YYYY, hh:mm:ss TT'))
Thanks, would you be able to provide me with an example of this?