Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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')
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')
Date(reloadtime(),'MMM/DD/YYYY')
Hi,
Check your main script variable settings where you should see the basic configurations
OR
=Date(FLOOR(ReloadTime()),'MMM/D/YYYY')
Only Date(reloadtime(),'DD-MMM-YYYY') worked for me 🙂