reloadtime format

[#1]

Hi all,

      i want to change the format of reloadtime() function..now it is showing as ''9/16/2014''. i want this to "sep/16/2014''  

      Any response would be helpful

[MK_QSL · Accepted solution]

Date(Date#(ReloadTime(),'M/D/YYYY'),'MMM/D/YYYY')

or

Date(Date#(ReloadTime(),'M/DD/YYYY'),'MMM/DD/YYYY')

or

=Date(Floor(TimeStamp#(ReloadTime(),'M/D/YYYY hh:mm:ss')),'MMM/D/YYYY')

or

=Date(Floor(TimeStamp#(ReloadTime(),'M/DD/YYYY hh:mm:ss')),'MMM/DD/YYYY')

[Anonymous]

Date(reloadtime(),'MMM/DD/YYYY')

[senarath]

Hi,

Check your main script variable settings where you should see the basic configurations

[MK_QSL]

OR

=Date(FLOOR(ReloadTime()),'MMM/D/YYYY')

[Kaushik2020]

Only Date(reloadtime(),'DD-MMM-YYYY') worked for me 🙂